Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why number 8 turns into a 0?
When I type a 16-digit number in a cell, and the last digit is "8", the
number becomes a "0". I changed the formatting of the cells and still continues to make "8" a "0". Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why number 8 turns into a 0?
xl max 15 so format as text or put in '11111111
-- Don Guillett SalesAid Software "Ricardo" wrote in message ... When I type a 16-digit number in a cell, and the last digit is "8", the number becomes a "0". I changed the formatting of the cells and still continues to make "8" a "0". Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why number 8 turns into a 0?
Hi Ricardo,
Excel's precision is 15 decimal digits. If you need more (probably as an identifier, like a credit card number), Format the cell as Text *before* you enter the number, or precede the number with an apostrophe (which will not show). You can't calculate with a "number" like that -- Kind regards, Niek Otten Microsoft MVP - Excel "Ricardo" wrote in message ... | When I type a 16-digit number in a cell, and the last digit is "8", the | number becomes a "0". I changed the formatting of the cells and still | continues to make "8" a "0". Thanks, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why number 8 turns into a 0?
Ricardo
You have run up against Excel's 15-digit limit to significant places. Pre-format the cells as Text or enter the numbers preceded by an apostrophe, which won't show in the cells. Gord Dibben MS Excel MVP On Thu, 14 Dec 2006 13:39:01 -0800, Ricardo wrote: When I type a 16-digit number in a cell, and the last digit is "8", the number becomes a "0". I changed the formatting of the cells and still continues to make "8" a "0". Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show Next Number in sequence | Excel Worksheet Functions | |||
Selecting the first time a number appears (part 2) | Excel Discussion (Misc queries) | |||
NUMBER OF ROWS IN A DYNAMIC RANGE | Excel Worksheet Functions | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) |