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