Hi Zygy,

To format the whole sheet:
.. click on the grey rectangle in the upper left corner (ie just above row 1
and to the left of column A)
.. use Format|Cells|Number and choose the format you want.

Note that the above applies to a single worksheet. If you want to apply the
formatting to all worksheets in a workbook:
.. select the first worksheet in the workbook,
.. Click on the grey rectangle in the upper left corner
.. click on the tab for the last worksheet in the workbook
.. use Format|Cells|Number and choose the format you want.

Cheers
PS: It's usually best to continue a line of discussion in the original
thread.


"Zygy" wrote in message
...
Thank you for the answer, but I tried that and it does not work. In any
case
that is supposed to change only the selected cell, it does not change the
negative values occurring in other places, therefore I must have it for a
whole sheet. Macroport stated that it is possible, but he did not say
which
way!

It would be a good idea if persons making suggestions to solve a problem
ALWAYS stated how to achieve this as it is done by the professionals.

"broro183" wrote
in
message ...

HI Zygy,

Please check your original thread:

http://excelforum.com/showthread.php...32#post1572732

I think you know how to do this (?), but once your range is selected go
to Format - Cells - Number, select Currency (in left column) and choose
the format you want from the negative values area.

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=537425