| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help! Automatically moving decimal points
Thank you so much. You just saved my skin.
"Niek Otten" wrote: ToolsOptionsEdit tab, Uncheck Fixed decimal -- Kind regards, Niek Otten Microsoft MVP - Excel "Noodles" wrote in message ... | Its a little embarrassing asking something so seemingly simple but for the | life of me I can not figure this out. I just installed Excel 2003 on a | computer and whenever I input a number without specifying a decimal it | automatically puts on in two spaces to the left. For example if I input 2000 | and hit enter it becomes 20.00. If I input 2 it becomes 0.02. However if I | make it 2. it stays 2. This is becoming extremely annoying as one small | mistake on one of these spreadsheets could get me in major trouble with the | boss. Please help! | | Thanks in advance, | | Noodles |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert decimal commas to decimal points? | Excel Discussion (Misc queries) | |||
| decimal points in my spreadsheet | Excel Discussion (Misc queries) | |||
| Formatting Decimal points | Excel Discussion (Misc queries) | |||
| Decimal Points | Excel Worksheet Functions | |||
| Decimal points not needed | Excel Worksheet Functions | |||
Threaded Mode
