Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Accounting Format Parentheses
I have Excel 2002 (XP) and want to display negative numbers in parentheses in
ACCOUNTING FORMAT instead of with a minus sign. I know this is possible as a standard feature (I have done it before on a previous machine) and I think there was a KB patch for this flaw. Anyone know of where I might find the fix? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Accounting Format Parentheses
Look in Tools, cells, Number instead of Accounting.
--- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "tiggy2" wrote in message ... I have Excel 2002 (XP) and want to display negative numbers in parentheses in ACCOUNTING FORMAT instead of with a minus sign. I know this is possible as a standard feature (I have done it before on a previous machine) and I think there was a KB patch for this flaw. Anyone know of where I might find the fix? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
accounting format for zero show 0.00 in one cell "-" in another | Excel Discussion (Misc queries) | |||
why does currency format change to number format? | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
Display 0's in Accounting format | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) |