View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Default cell format in Excel

Correct the setting at:

<Tools <Options <Edit tab,
And *Uncheck*
"Fixed Decimal Places".
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"kat0301" wrote in message
...
Why would Excel default to a display of (example) 0.03 when the number 3 is
entered in a cell? When the Format Cells dialog box is opened, the format
shows as General. This happens on every new and existing workbook on a
particular PC. Could there be a setting somewhere or is it a fault in the
program?