Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
last number defaluts to zero
When I enter a large number into and Excel, the last digit of the number
defaults to zero. I have tried all the different cell formats available and none of them allow a different ending digit - other than zero 0 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
last number defaluts to zero
Excel can only handle 15 digits. Precede the number with a single quote
(apostrophe). -- Gary''s Student - gsnu200761 "alank" wrote: When I enter a large number into and Excel, the last digit of the number defaults to zero. I have tried all the different cell formats available and none of them allow a different ending digit - other than zero 0 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
last number defaluts to zero
If by large you mean 16 digits or more, that's the nature of the beast. Excel
can handle 15 digits of precision only. If you're entering something like a credit card# (or any # which doesn't require arithmetic operations), enter it as text -- either precede it with an single quote (which won't show) or format the cell as text. Then you'll get all your digits. "alank" wrote: When I enter a large number into and Excel, the last digit of the number defaults to zero. I have tried all the different cell formats available and none of them allow a different ending digit - other than zero 0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |