ExcelBanter - how do i remove conversion of 0.001 into 1

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i remove conversion of 0.001 into 1 (https://www.excelbanter.com/excel-discussion-misc-queries/16431-how-do-i-remove-conversion-0-001-into-1-a.html)

ndnlhr

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

Bob Phillips

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

All times are GMT +1. The time now is 02:00 AM.