Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
the old guy
 
Posts: n/a
Default change the negative sign to brackets but no choice is available

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?

  #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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN JON Excel Discussion (Misc queries) 3 July 18th 05 06:35 PM
Can I change the Insert Function button to an equals sign? Jokeyjojo Excel Discussion (Misc queries) 1 January 17th 05 05:45 PM
highlighting positive or negative change Dave Excel Discussion (Misc queries) 2 December 27th 04 01:28 PM
How do I change row height to 16.0? I get choice of 15.6 (26 Pix. jlloyd Excel Discussion (Misc queries) 4 December 9th 04 04:47 PM
how to change the state of a number in a cell from negative to po. Steve11 Excel Discussion (Misc queries) 1 November 29th 04 07:00 AM


All times are GMT +1. The time now is 07:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"