Is there a way of ALWAYS getting the figures of a negative value of currency
shown in read on a worksheet? If there is how do I arrange it?
I tried FormatCellsNumber and Currency, where I highlighted the red -£
figures, but I still get the negative Currency numbers in black. My OS is
Win.XPPro.

Hi Zygy,

The formatting options only apply to the cells selected at the time the
options are applied. If you want a whole row/colum/worksheet to be affected,
all of that row/colum/worksheet must be selected.

Cheers


"Zygy" wrote in message
...
Is there a way of ALWAYS getting the figures of a negative value of
currency
shown in read on a worksheet? If there is how do I arrange it?
I tried FormatCellsNumber and Currency, where I highlighted the red -£
figures, but I still get the negative Currency numbers in black. My OS is
Win.XPPro.

the format cells on works for what ever range you have highlited


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537119

Thank you for the reply. Please advise me how do I apply this to a whole
worksheet. Thank you.
"macropod" wrote in message
...
Hi Zygy,

The formatting options only apply to the cells selected at the time the
options are applied. If you want a whole row/colum/worksheet to be
affected,
all of that row/colum/worksheet must be selected.

Cheers


"Zygy" wrote in message
...
Is there a way of ALWAYS getting the figures of a negative value of
currency
shown in read on a worksheet? If there is how do I arrange it?
I tried FormatCellsNumber and Currency, where I highlighted the red -£
figures, but I still get the negative Currency numbers in black. My OS is
Win.XPPro.

Hi Zygy,

Selecting the whole worksheet can be done in a couple of ways:
* Click the grey square which appears at the intersection of the row &
column headers at the top left of the screen, or
* select any cell and press [ctrl + a] (hold the control key & press
the letter A).

You can then apply the formatting as you normally would.

However, this may lead to quite an increase in your file size. My
preferred option is to just apply the formatting to the used range (but
this may be a nusiance if you are regularly adding more data to the
bottom/side of your spreadsheet. To just apply the formatting to the
used range press:
[ctrl + home], then press [ctrl + shift + end], and apply the
formatting.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=537119