Displaying a 12-digit Number

  • Thread starter Thread starter John
  • Start date Start date
J

John

How can I have a cell display a 12-digit number?
Currently, when you would type the number 123456789012,
1.23457E+11 is displayed.

As I need to have the spreadsheet saved as a Text
Delimited file, even when formatting the cell as text does
not work, because when the file is being converted, it
sees the cell as a number, and brings me back to square
one. Any ideas?? Thank you.
 
hi,

you can use custom formatting.

for always 12 digits:

000000000000

for non-leading zeros:

############

please note: these will always be text now
 
Thanks, however I have tried custom formatting, yet still,
when the file is saved as a text-tab delimited file, it
changes back to 1.23457E+11. Is there any way of having
excel not change the format when converting??
thanks

-John
 
Hi John,
The reason you see it as 1.23457E+11 is because
your cell is not wide enough. But if it is supposed
to be 12 digits including leading zeros, format as
Frank indicated 000000000000

Change the file extension from .csv to .txt so when you
read the file back into Excel it will allow you to choose
a text format. If that doesn't wok precede the value
with a prefix that you later remove after formatting the
column as text.
 
Back
Top