Dollar sign

[Ralphael1]

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

Ralphael, the OLD one

 

[Don Guillett]

change the format

 

[Gord Dibben]

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


Gord Dibben Excel MVP

 

[Ralphael1]

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

 

[Don Guillett]

format>number>lets you select the decimals. Look again

 

[Ralphael1]

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

Kudos'

Ralph

 

[Don Guillett]

glad to help