when i type 5 then it shows.006
in [Functions]
|
Prev: fill color a protected cell without unprotecting worksheet
Next: Count a value excluding duplicates depending on a set criteria
From: gauri on 1 Feb 2010 12:45 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
From: Eduardo on 1 Feb 2010 12:49 Hi, Highlight the cells, right click on the mouse, format cells, number, choose your preference "gauri" wrote: > 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
From: Luke M on 1 Feb 2010 13:13
In addition to Eduardo's suggestion, you might check Tools - Options - Edit, and make sure you don't have "Fixed decimals" activated. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "gauri" wrote: > 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 |