numeric entered automatically divided 100!
 

Please help! I am using Office 2007 and I have problem with my excel,
everytime I enter numeric into the cell, it is automatically divide by 100,
for example: If I type 10,000 and when it's entered, the number entered in
the cell is 100.
I have tried formatted the cell but doesn't work.
Please help.

Anastasia

numeric entered automatically divided 100!
 

Anastasia,

Not quite sure where it is in 2007 but in 2003 you would first check

Tools|Options|Edit
and uncheck 'Fixed decimal places'

Mike

"Anastasia" wrote:

Please help! I am using Office 2007 and I have problem with my excel,
everytime I enter numeric into the cell, it is automatically divide by 100,
for example: If I type 10,000 and when it's entered, the number entered in
the cell is 100.
I have tried formatted the cell but doesn't work.
Please help.

Anastasia