| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input numbers appearing incorrectly on spreadsheet
When I type a number into excel the number appearing in the cell is divided
by 100. i.e. if I input 1 the number in the cell is 0.01 but if I input 1.0 the number is correctly displayed as 1 Any ideas, it driving me to drink |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Input numbers appearing incorrectly on spreadsheet
Try,
Tools|options|Edit Un-Check fixed decimal places. Mike "Error in inputting numbers into excel" wrote: When I type a number into excel the number appearing in the cell is divided by 100. i.e. if I input 1 the number in the cell is 0.01 but if I input 1.0 the number is correctly displayed as 1 Any ideas, it driving me to drink |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Input numbers appearing incorrectly on spreadsheet
ToolsOptionsEdit.
Clear the checkbox at "Fixed Decimal Places" Gord Dibben MS Excel MVP On Fri, 7 Mar 2008 00:25:01 -0800, Error in inputting numbers into excel <Error in inputting numbers into wrote: When I type a number into excel the number appearing in the cell is divided by 100. i.e. if I input 1 the number in the cell is 0.01 but if I input 1.0 the number is correctly displayed as 1 Any ideas, it driving me to drink |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does excel sometimes subtract numbers incorrectly? | Excel Worksheet Functions | |||
| numbers not appearing correctly in formula bar | Excel Worksheet Functions | |||
| Row of numbers adding incorrectly. | Excel Discussion (Misc queries) | |||
| ####### appearing on top of numbers | Excel Discussion (Misc queries) | |||
| Help - Separating numbers appearing on the right of a text string | Excel Worksheet Functions | |||
Linear Mode
