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.
 
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

Sharing Worksheet 1
How to automatically number an index column 13
Match and delete rows on two different sheets from reference numbers 4
Cannot get previous data after ctrl + w 0
Newbie Question 6
Sequential Numbering problem 0
Excel How to Autocomplete text/string within a single cell, between different worksheets 1
To give back ground colour for entire row on certain condition 12

Back
Top