View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 9200000000000009 display incorrectly.

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.

"Summer" wrote in message
...
I input 9200000000000009 into Excel, but display to 9200000000000000, the
latest digit is incorrectly.