Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I keep Excel from dropping my numbers to 0 after 15 digits
I am doing large number data entry, and excel is automatically converting my
numbers to zeros after the first 15 digits... 123456789123456789 comes out looking like 123456789123456000 It also appears to be calculating against the incorrect values. Can anyone help??? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I keep Excel from dropping my numbers to 0 after 15 digits
Excel keeps track of 15 significant digits.
If you're using these as text (phone numbers/id numbers), then preformat those cells as text or start your data entry with an apostrophe: '12345678901234567890 Are you trying to do calculations against these values? Topmom5 wrote: I am doing large number data entry, and excel is automatically converting my numbers to zeros after the first 15 digits... 123456789123456789 comes out looking like 123456789123456000 It also appears to be calculating against the incorrect values. Can anyone help??? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare two Excel columns of numbers and see non-matches | Excel Worksheet Functions | |||
Am I able to use the dialing feature from numbers in Excel? | Excel Discussion (Misc queries) | |||
How do I change format of page numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
Can Excel evaluate a series of numbers | Excel Discussion (Misc queries) | |||
Excel file saved as csv - dropping zeros | Excel Discussion (Misc queries) |