View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Goldabraun Goldabraun is offline
external usenet poster
 
Posts: 1
Default 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