5 Replies Latest reply on Sep 19, 2013 2:32 PM by Alex Kerin

# Display 16 digit number

Hello,

I'm trying to figure out how to display a 16 digit number not in scientific notation or without changing the last digit to 0 (as currently the case).  We have to get these identification numbers as they appear in the details section of our report.

I've tried converting to string

I've tried multiplying the number by 1 and then converting to string

I've tried multiplying by 10 and dividing by 10 and then converting to string

I've tried adding 1 and subtracting 1 and then converting to string.

I've tried taking the left 16

Any ideas?

Thanks!!!!!

• ###### 1. Re: Display 16 digit number

I'm not sure I understand the problem.  What is displaying is a 16 digit number.  And the field "Fake Number" already has 16 digits with a 0 at the end.  Can you post a workbook with the original numbers?  If you want to display the first 15, you can obviously change your calculation to include only the first 15 characters.  I did that in the attached--but again, I'm not sure I understand the problem.

• ###### 2. Re: Display 16 digit number

I think I understand.  I replicated a 16 digit number in Excel and saw the issue--but I was able to change it by using a Custom Number format with 16 # symbols.

1 of 1 people found this helpful
• ###### 3. Re: Display 16 digit number

I think you need to bring it in as a string in the first place - JET is possibly bringing it in and doesn't have the available bits. You could do this with some fake rows of data at the top of the file that contain strings, or edit the schema.ini.

• ###### 4. Re: Display 16 digit number

The problem is that there is an actual last digit - Excel and Tableau are changing the last digit to 0.  I'll see if I can get the system of record to output as a string and then bring it in.

• ###### 5. Re: Display 16 digit number

This isn't Tableau - Excel will truncate it unless it goes in as a text cell (with a ' before the number). If it's a text file, it is JET doing the rounding - you need to change the schema.ini to tell JET to treat it as a string (or possibly longint)