View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beege
 
Posts: n/a
Default change the negative sign to brackets but no choice is available

Old Guy,

Format / Cells / Currency

There should be a list that has differnt formats for neg. numbers, including
your ($1.00).


Otherwise, Custom format using:
$#,##0.00_);($#,##0.00)

Beege

"the old guy" <the old wrote in message
...
I have 2003 edition of office and using Excel. I want to fomat the cells
as
($1.00) but I only have the option of -$1.00 how do I add a format to
currency to read this way?