Improper General Number Format

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

The General Number Format on a new worksheet has changed
to two decimals. If you enter 1 you get .01. This happens
on all brand new worksheets.

How can I reset this?

I'm using Windows 95 and Office 2000

Thanks

Paul
 
Paul,

Go into Tools>Options>Edit, and if the Fixed Decimal Places box is checked,
uncheck it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top