How to return the default setting of numbering format in Excel?
 

When I encode a number without decimal, it gives me a number with 2 placed
decimals (ie enter 156, returns 1.56). I tried adjusting the Format Cells but
to no avail. Can anyone help me please?

How to return the default setting of numbering format in Excel?
 

Saturn

ToolsOptionsEditFixed decimal (un-check)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"saturn" wrote in message
...
When I encode a number without decimal, it gives me a number with 2 placed
decimals (ie enter 156, returns 1.56). I tried adjusting the Format Cells
but
to no avail. Can anyone help me please?