Posted to microsoft.public.excel.worksheet.functions
|
|
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?
|