Thread: How to return the default setting of numbering format in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge Nick Hodge is offline
external usenet poster
  
Posts: 1,173
Default 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?


Reply With QuoteReply With Quote