Decimal place formatting

  • Thread starter Thread starter Big Ron
  • Start date Start date
B

Big Ron

My accounts spreadsheet defaults to "£.99" if I enter "99" even though it
should read "£99.00".

How can this be fixed when the usual Format-Currency-£ and two decimal
places is chosen? Is it something to do with master settings or templates
or something?

TIA

Ron
 
Better to uncheck the Fixed Decimal Places optionbox.

If set at 2 then 99 will be entered as .99


Gord Dibben MS Excel MVP
 
Back
Top