Please Help! Automatically moving decimal points

[Noodles]

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

 

[Niek Otten]

Tools>Options>Edit tab, Uncheck Fixed decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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

 

[Conan Kelly]

Noodles,

Tools > Options... > Edit tab:

Uncheck "Fixed decimal"

HTH,

Conan

 

[Noodles]

Thank you so much. You just saved my skin.