Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
long number ends in 000
Simple Question: when typing a long number in Excel (exceeding 15
characters), the last last numbers automatically turn to 0 (like in a ROUND formula). I know this can be avoided by changing the number to text (eg by inserting space or letter somewhere between the numbers) but because in this case it's many other users who input the numbers, unaware of the bug, I really need a way for them to be able to do so without having the right end always change to "0" automatically... any tips ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
long number ends in 000
this happens when Excel's max precision is exceeded - which is exactly
15 places one way is to store it as text preceded by a single ' (apostrophe) On 22 Gru, 09:45, justanotherdayatwork wrote: Simple Question: when typing a long number in Excel (exceeding 15 characters), the last last numbers automatically turn to 0 (like in a ROUND formula). I know this can be avoided by changing the number to text (eg by inserting space or letter somewhere between the numbers) but because in this case it's many other users who input the numbers, unaware of the bug, I really need a way for them to be able to do so without having the right end always change to "0" automatically... any tips ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
long number ends in 000
Format the cells as text before entering the numbers
BTW it's not a bug; it is the limit of Excel's precision; 15 decimal digits -- Kind regards, Niek Otten Microsoft MVP - Excel "justanotherdayatwork" wrote in message ... Simple Question: when typing a long number in Excel (exceeding 15 characters), the last last numbers automatically turn to 0 (like in a ROUND formula). I know this can be avoided by changing the number to text (eg by inserting space or letter somewhere between the numbers) but because in this case it's many other users who input the numbers, unaware of the bug, I really need a way for them to be able to do so without having the right end always change to "0" automatically... any tips ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter will not work -- Number Ends With | Excel Discussion (Misc queries) | |||
"Bug" in number format for long number entries? | Excel Discussion (Misc queries) | |||
filter using "ends with" and 3 choices? Ex: ends with 1,2 or3 | Excel Worksheet Functions | |||
Extract sub-string of number from field of long series of numbers | Excel Worksheet Functions | |||
Auto Fill Series when number ends in -1 | Excel Discussion (Misc queries) |