when i type 5 then it shows.006

  • Thread starter Thread starter gauri
  • Start date Start date
G

gauri

hi all
i am new to excel,i was making some sheet and when i type number 5 or any
number it show.005,please let me know what to do
 
Hi,
Highlight the cells, right click on the mouse, format cells, number, choose
your preference
 
In addition to Eduardo's suggestion, you might check Tools - Options - Edit,
and make sure you don't have "Fixed decimals" activated.
 
Back
Top