Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does excel replace my 16th number with a zero?
I am trying to type 16 numbers in a column, but no matter what the last
number i type is, excel changes it to 0. I've tried formatting the cell as text and custom, but nothing is working. How can I make it stop? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does excel replace my 16th number with a zero?
Enter them in cells preformatted as Text or with a leading apostrophe
('). Excel is limited to 15 decimal digits of precision, so to work with numbers with more digits than that will require you to use string functions to manipulate parts of the numbers. If this post helps click Yes --------------- Jacob Skaria "DebR" wrote: I am trying to type 16 numbers in a column, but no matter what the last number i type is, excel changes it to 0. I've tried formatting the cell as text and custom, but nothing is working. How can I make it stop? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i use excel to replace blank cells with the number 9 | New Users to Excel | |||
How to restrict zeros in a number from 16th digit onwards | Excel Discussion (Misc queries) | |||
How to check for and replace the largest number in excel | Excel Worksheet Functions | |||
16th digit in the cell changes to a zero?? | Excel Discussion (Misc queries) | |||
16th digit changes?? Problem,16th digit changes to a zero.... | Excel Worksheet Functions |