cells

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

Guest

When I put a number ex. (14) into a cell , then click to another cell
the number 14 changes to a .01. Any number I put in then click out of that
cell
the number will change to something different. This is in my excel
workbook.
 
Take a look at Tools/Options/Edit and check if the Fixed decimal places
checkbox is checked.
 
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

Red cell for negative numbers in Excel 1
Access Running Balance in Access 1
Custom auto filter (Dates) 2
Default number format in Excel 1
Excel Selected Cell's Content Magnification 3
Time Sum in Excel 1
Searching the formula (not the value) for a text string 1
Last Modified By in a cell by user 3

Back
Top