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

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

$ 1200.03
$ 120.88


Any help much appreciated.

Thanks

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

FormatCellsNumber tab, choose Accounting category

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Isis" wrote in message ...
| can this be done so that cells look something like this;
|
| $ 1200.03
| $ 120.88
|
|
| Any help much appreciated.
|
| Thanks

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

"Niek Otten" wrote in
:

FormatCellsNumber tab, choose Accounting category


Thanks Niek,

Regards