Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
integers entered automatically divide by 10
It seems that my Excel 2003 has adefault which causes any integer that is
entered to be automatically divided by 10 when entered into the cell. Can anyone please tell me how to remove this annoying feature? Many thanks in advance. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
integers entered automatically divide by 10
Hi Alan
ToolsOptionsEdit tab uncheck fixed decimal places HTH Martin |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
integers entered automatically divide by 10
Many thanks. I thought it must be something straightforward but I was
checking ''cell properties''. Once you know.......... "MartinW" wrote: Hi Alan ToolsOptionsEdit tab uncheck fixed decimal places HTH Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
integers entered are converted into decimal places e.g. 1 = 0.01 | Excel Discussion (Misc queries) | |||
How do I get data automatically entered into a cell? | Excel Worksheet Functions | |||
Automatically entered decimal point. | Excel Worksheet Functions | |||
Numbers entered are being automatically converted ? | Excel Discussion (Misc queries) | |||
A list of Consecutive Integers, can I search for missing integers | Excel Worksheet Functions |