18 digit number

K

kit

i typed the 18 digit number, 272908000000012040 in Excel. the number is
displayed in Scientific notation. However, the number in the edit box
appears as 272908000000012000. If the number is formated as number, it
still reads wrong.

What am I doing wrong? I want to custom format the number to read
27-29-08-000000-012040. However, excel changes the last three digits
to 000. :confused:
 
V

Vasant Nanavati

Excel can only handle 15 digits. You may want to format it as text if you
are not using it in calculations.
 
P

Peo Sjoblom

Excel have 15 digits precision thus the truncation, precede the entry with
an apostrophe when you enter it and enter the
hyphens as well. I assume you are not calculating anything
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complicated Formula Problem 10
Format Number 000000 00000 000000 0
Page numbering with Merged Document and IF statements 1
Two digit number with one decimal, or three digit number 2
numbers convert to formula in csv 2
Custom formatting in Excel 2007 1
How do you change single digits to recognized double digits? 4
Number Formatting help 3

Top