Number entered into cell is dividide by 100. Not fixed by Cell For
 

I use Excel 2003.
When I enter a number into a cell it automatically divides it by 100. For
example if I enter in "8" and hit enter, "0.08" shows up in the cell.

Making a different selection in "Cell Format" does not fix the problem. I
have also tried looking under Tools/options/edit none of those options make a
difference either.

This problem started within the last two weeks. Before then it was working
normally. When I create new workbooks they all behave this way. Also if I
open a workbook from a project before these problems, new data entered takes
this format.

Is it possible that I could have hit some combination of keys unknowingly
that could turn on this issue? For example, the otherday I stumbled accross
the Euro symbol because I must have hit the right combination of asci code to
enter that symbol.

I would be very thankful for any help

Number entered into cell is dividide by 100. Not fixed by Cell For
 

Tools/Options/Edit. Uncheck the Fixed Decimals checkbox.


In article ,
"Goldabraun" wrote:

I use Excel 2003.
When I enter a number into a cell it automatically divides it by 100. For
example if I enter in "8" and hit enter, "0.08" shows up in the cell.

Making a different selection in "Cell Format" does not fix the problem. I
have also tried looking under Tools/options/edit none of those options make a
difference either.

This problem started within the last two weeks. Before then it was working
normally. When I create new workbooks they all behave this way. Also if I
open a workbook from a project before these problems, new data entered takes
this format.

Is it possible that I could have hit some combination of keys unknowingly
that could turn on this issue? For example, the otherday I stumbled accross
the Euro symbol because I must have hit the right combination of asci code to
enter that symbol.

I would be very thankful for any help

Number entered into cell is dividide by 100. Not fixed by Cell For
 

Toolsoptionsfixed decimal places set to 2...uncheck it.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Goldabraun" wrote in message
...
I use Excel 2003.
When I enter a number into a cell it automatically divides it by 100. For
example if I enter in "8" and hit enter, "0.08" shows up in the cell.

Making a different selection in "Cell Format" does not fix the problem. I
have also tried looking under Tools/options/edit none of those options
make a
difference either.

This problem started within the last two weeks. Before then it was working
normally. When I create new workbooks they all behave this way. Also if I
open a workbook from a project before these problems, new data entered
takes
this format.

Is it possible that I could have hit some combination of keys unknowingly
that could turn on this issue? For example, the otherday I stumbled
accross
the Euro symbol because I must have hit the right combination of asci code
to
enter that symbol.

I would be very thankful for any help