View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 422
Default Decimal place formatting

Check Tools, Options, Edit Tab for Fixed decimals setting; if 0 then
change to 2.


"Big Ron" wrote in message
:

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