software

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 Formatgt;Cellsgt;Numbergt; 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.

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

the format cells on works for what ever range you have highlited--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=537119Thank you for the reply. Please advise me how do I apply this to a whole
worksheet. Thank you.
quot;macropodquot; gt; wrote in message
...
gt; Hi Zygy,
gt;
gt; The formatting options only apply to the cells selected at the time the
gt; options are applied. If you want a whole row/colum/worksheet to be
gt; affected,
gt; all of that row/colum/worksheet must be selected.
gt;
gt; Cheers
gt;
gt;
gt; quot;Zygyquot; gt; wrote in message
gt; ...
gt;gt; Is there a way of ALWAYS getting the figures of a negative value of
gt; currency
gt;gt; shown in read on a worksheet? If there is how do I arrange it?
gt;gt; I tried Formatgt;Cellsgt;Numbergt; and Currency, where I highlighted the red -£
gt;gt; figures, but I still get the negative Currency numbers in black. My OS is
gt;gt; Win.XPPro.
gt;gt;
gt;gt;
gt;
gt;

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 amp;
column headers at the top left of the screen, or
* select any cell and press [ctrl a] (hold the control key amp; 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 amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=537119