| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbers will not format properly
Excel's precision is 15 decimal digits.
If you need more and don't have to calculate with them (like credit card numbers); precede the entry with an apostrophe (that will not show in the cell) or format the cell as text before entering the number. -- Kind regards, Niek Otten Microsoft MVP - Excel "JerzeeGurl" wrote in message ... |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. | |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbers will not format properly
Thank you, both options worked!
"Niek Otten" wrote: Excel's precision is 15 decimal digits. If you need more and don't have to calculate with them (like credit card numbers); precede the entry with an apostrophe (that will not show in the cell) or format the cell as text before entering the number. -- Kind regards, Niek Otten Microsoft MVP - Excel "JerzeeGurl" wrote in message ... |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. | |
| Reply |
| 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) | |||
Linear Mode
