Thread: Formatting monetary amounts with currency indicator on extreme left and amount right ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default 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


Reply With QuoteReply With Quote