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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Tools>options>fixed decimal places set to 2...uncheck it.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

enter key behavior - by sheet 4
Last Modified By in a cell by user 3
Number Transforms Into Euros 2
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
If specific cell is not empty, copy (or enter) formulas and format 2
Data Validation when entering hours over 24 8
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Time issues in code 6

Back
Top