| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
when i type 5 then it shows.006
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
when i type 5 then it shows.006
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
when i type 5 then it shows.006
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I type 30% but 30... shows in cell - why? | Excel Discussion (Misc queries) | |||
| When I type "13" the spreadsheet shows "14." Possibilities? | Excel Discussion (Misc queries) | |||
| when I type 100 in a cell 181 shows | Excel Discussion (Misc queries) | |||
| cell shows 20. Formula shows 20. why not 540/27 | Excel Worksheet Functions | |||
| using date function, month shows as January when i type (12) | Excel Discussion (Misc queries) | |||
Linear Mode
