Home |
Search |
Today's Posts |
#1
|
|||
|
|||
15 digits???
I was just noticing that I can not enter more than 15 digits in a cell, the
16th always changes to zero. Why is this, and is there any way to fix this? All sugesstions are welcome, but I also want to keep it in the format of "0000 0000 0000 0000" I've been doing this by making a custom format. Thanks a lot!!!! |
#2
|
|||
|
|||
It has to be text. A number can have only 15 decimal digits. Either
precede it with an apostrophe ('), or pre-format the cell (Format - Cells - Number tab) as text. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "muckali" wrote in message ... I was just noticing that I can not enter more than 15 digits in a cell, the 16th always changes to zero. Why is this, and is there any way to fix this? All sugesstions are welcome, but I also want to keep it in the format of "0000 0000 0000 0000" I've been doing this by making a custom format. Thanks a lot!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Least number of digits in Y-axis labels | Charts and Charting in Excel | |||
How do I format cells to a specific number of digits? | Excel Discussion (Misc queries) | |||
Using a IF formula, I would like to drop the 2 digits in front of. | Excel Discussion (Misc queries) | |||
Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
I have a col. with 6 digit nos to convert to 3 cols of 2 digits | Excel Discussion (Misc queries) |