Thread: cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default cells

Take a look at Tools/Options/Edit and check if the Fixed decimal places
checkbox is checked.


In article ,
Mary wrote:

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.