when i type 5 then it shows.006

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
 
E

Eduardo

Hi,
Highlight the cells, right click on the mouse, format cells, number, choose
your preference
 
L

Luke M

In addition to Eduardo's suggestion, you might check Tools - Options - Edit,
and make sure you don't have "Fixed decimals" activated.
 

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


Top