Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
number input error
All of a sudden whenever I input a number in any workbook in any column that
number is 100th of the input number. e.g. if I input 6 the number shown is 0.06, if 60 it shows 0.6. I have tried formatting the columns but it does not help to change this effect. It applies to all work books even those unopened for a few months |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
number input error
Tools/ Options/ Edit
Uncheck "Fixed decimal places" -- David Biddulph "Mick" wrote in message ... All of a sudden whenever I input a number in any workbook in any column that number is 100th of the input number. e.g. if I input 6 the number shown is 0.06, if 60 it shows 0.6. I have tried formatting the columns but it does not help to change this effect. It applies to all work books even those unopened for a few months |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
number input error
On Sun, 24 Aug 2008 02:32:00 -0700, Mick
wrote: All of a sudden whenever I input a number in any workbook in any column that number is 100th of the input number. e.g. if I input 6 the number shown is 0.06, if 60 it shows 0.6. I have tried formatting the columns but it does not help to change this effect. It applies to all work books even those unopened for a few months Tools/Options On one of the tabs you will see an option to automatically insert a decimal point -- clear that. In 2007, check under the Office Button/ Excel Options --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
number input | New Users to Excel | |||
number input box | Excel Worksheet Functions | |||
How do I change . to : when input in a time sheet by error | New Users to Excel | |||
Formula input error help | Excel Discussion (Misc queries) |