cells will not accept decimals.will not allow any retype with deci

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

Guest

in excel only the cell size will not accept the decimal point. you can incert
the decimal but it will revert to no decimal. Also the decimal/del key on the
key pad
prints a zero rather than a decimal. Only when you open the cell will the
decimal
/del key print a decimal,close the cell it will print a zero again.
 
Hi detmar

Your cells are most likely formatted as numbers, no decimal figures. Select
the cell, right click, click on format cells, and change the number format to
numbers, 2 decimal points, and you will see your decimal fractions
 
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

How do I work with part of a cell entry? 4
Hiding zero values 3
Formatting cells as text 2
Decimal point will not hold 2 places in Excel 2003 3
Fixed Decimals in Excel 2007 4
Wildcards with numbers....* & ? not working 2
Logical test in IF statement returning incorrect result 3
validation for decimals 4

Back
Top