Setting default formats

[Dave]

Seems every time I format a cell for currency (I only use US dollars), I
have to select the $ symbol, and 2 decimal places. Is there a way to set
these two items as defaults?
Thx
Dave

 

[smw226 via OfficeKB.com]

Hi Dave,

On the formatting Toolbar there is an icon which looks like a bank note and a
stack of coins.

If you click on this while you have the cells you want to format highlighted
it should convert it to the currency format for you.

HTH

Simon

=========================================================================

Seems every time I format a cell for currency (I only use US dollars), I
have to select the $ symbol, and 2 decimal places. Is there a way to set
these two items as defaults?
Thx
Dave

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200801/1

 

[Tyro]

What do you have set in Control Panel/Regional and Language
Settings/Currency?

Tyro

 

[Dave]

Thank you all - I'm in business. Got both methods working. First time I
was ever in Regional and Language

Really appreciate the help

Dave

 

[Tyro]

You're welcome

Tyro

Thank you all - I'm in business. Got both methods working. First time I
was ever in Regional and Language

Really appreciate the help

Dave