| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i remove conversion of 0.001 into 1
when i put any numeric value in excell it is displayed in fractional mode for
eg. 1 is displayed as 0.001 |
|
#2
|
|||
|
|||
|
Go to ToolsOptionsEdit and uncheck the Fixed Decimal checkbox.
-- HTH RP (remove nothere from the email address if mailing direct) "ndnlhr" wrote in message ... when i put any numeric value in excell it is displayed in fractional mode for eg. 1 is displayed as 0.001 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 1 is converted in 0.001 in all excell files | Excel Discussion (Misc queries) | |||
| how do i remove conversion of 0.001 into 1 | Excel Discussion (Misc queries) | |||
| Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
| Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
| Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Linear Mode
