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

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

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

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