Setting default formats
 

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

Setting default formats
 

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

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

Dave wrote:
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.a...excel/200801/1

Setting default formats
 

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

Tyro

"Dave" wrote in message
...
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

Setting default formats
 

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" wrote in message
...

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

Tyro

"Dave" wrote in message
...
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

Setting default formats
 

You're welcome

Tyro

"Dave" wrote in message
...
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" wrote in message
...

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

Tyro

"Dave" wrote in message
...
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