9200000000000009 display incorrectly.

S

Summer

I input 9200000000000009 into Excel, but display to 9200000000000000, the
latest digit is incorrectly.
 
G

Guest

Hi

When formatted as a number (or General) Excel only displays to 15 digits. If
you wish to use more than that you'll have to format the cell as text before
you type into it, or precede your entry with a '

Hope this helps
Andy.
 
S

Summer

Thanks a lot. It works.

Andy said:
Hi

When formatted as a number (or General) Excel only displays to 15 digits. If
you wish to use more than that you'll have to format the cell as text before
you type into it, or precede your entry with a '

Hope this helps
Andy.
Click to expand...
 
Top