Decimal Places

  • Thread starter Thread starter pegasus.one
  • Start date Start date
P

pegasus.one

For years I've used the same spreadsheet, and when I typed
a currency amount into a cell (for example, a "3"), it
appeared as $3.00. This is the way I want it to be.

I don't know what I've done to change it, but now when I
type in a "3", it appears as $.03

I've gone into FORMAT - CELLS - NUMBER - CURRENCY, and
the "Decimal Places" field says "2".

What should I do to get get it back to the way it used to
be?
 
Peg,

Tool | Options | Edit...deselect fixed decimal

That should do it.

Hope that helps.

Regards,
Kevin
 
double check that one of your co-wrkers didn't change the
following setting

tools / options / edit - fixed decimal (middle of window)
 
Back
Top