Dollar sign

R

Ralphael1

Can I enter dollar amount without the $ appearing on the left side of
the cell?
Thanks,

Ralphael, the OLD one
 
G

Gord Dibben

Sure, just format the cells as Number or Currency rather than Accounting.


Gord Dibben Excel MVP
 
R

Ralphael1

Gord said:
Sure, just format the cells as Number or Currency rather than Accounting.
All well and good up to a point...but....5.00 appears as just 5. the
zeros after the decimal are nowhere to be seen...

Ralphael, the OLD one
 
R

Ralphael1

OK, Thanks, now I think I understand something that was palin as day I
should have seen.

Kudos'

Ralph
 
Top