Formatting monetary amounts with currency indicator on extreme left and amount right ?

I

Isis

can this be done so that cells look something like this;

$ 1200.03
$ 120.88


Any help much appreciated.

Thanks
 
N

Niek Otten

Format>Cells>Number tab, choose Accounting category

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| can this be done so that cells look something like this;
|
| $ 1200.03
| $ 120.88
|
|
| Any help much appreciated.
|
| Thanks
 
Top