Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help! Automatically moving decimal points
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help! Automatically moving decimal points
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help! Automatically moving decimal points
Noodles,
Tools Options... Edit tab: Uncheck "Fixed decimal" HTH, Conan "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 |
#4
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 |
Reply |
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 |