Setting default formats

D

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
 
S

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
Click to expand...

--
--------------------
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
 
D

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
 
T

Tyro

You're welcome

Tyro

Dave said:
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
Click to expand...
 
Top