Excel-Input numeric value in cell, it shows up as 1/100th of entry

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

Guest

I must have some cell formatting setup somewhere or something strange is
going on....

In a cell, I can enter a value of "1". Once I hit return to exit the cell,
the value in the cell is shown as "0.01", not "1". This is driving me crazy
and I have had miscalculating spreadsheets due to this issue.

To re-iterate, when I put a numeric value in a cell, it shows up as 1/100th
of the value.

Any suggestions to correct this.

Darin
 
Tools>Options>Edit.

Uncheck "fixed decimal places"


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

converting text cell to numeric cell 5
Strange things happening in Excel!!!!! 2
Count of numerical values within a cell 5
How to keep formula and be able to input value in cell? 0
Numbers showing Up Centered in Cell ? 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Matching numeric values. 1
In Excel - reverse the sign on a range of numeric cells 3

Back
Top