| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
9200000000000009 display incorrectly.
I input 9200000000000009 into Excel, but display to 9200000000000000, the
latest digit is incorrectly. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
9200000000000009 display incorrectly.
Thanks a lot. It works.
"Andy" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display results to certain number of significant figures | Excel Discussion (Misc queries) | |||
| I don't want to display any controls in excel. | Excel Discussion (Misc queries) | |||
| How do you display Greek and Russian languages in excel? | Excel Discussion (Misc queries) | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Linear Mode
