| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers will not format properly
I can't seem to get my number to display properly in my cell. I have a 16
digit number: 4185866472006934 without decimals or commas. When I format the cell to general I get this: 4.51259E+15 When I format the cell to number with no decimals I get this: 4185866472006930 I even tried to fomat the cell to special but the number appears twice in the cell. This is really frustration because I've never had this problem before. By the way I'm working with Exel 2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert german format numbers to british format | Excel Discussion (Misc queries) | |||
| text format doesn't work properly | Excel Discussion (Misc queries) | |||
| How do I format Zip codes to print properly in a Mail merge? | Excel Discussion (Misc queries) | |||
| Rounded numbers do not add properly. | Excel Worksheet Functions | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Threaded Mode
