Accounting Format Parentheses

**tiggy2** · July 24th, 2006, 09:49 PM posted to microsoft.public.excel.setup

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?

**David McRitchie** · July 30th, 2006, 03:00 PM posted to microsoft.public.excel.setup

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Customize date format	ROY A. DAY	Running & Setting Up Queries	20	February 6th, 2006 02:40 AM
Format Cells - Accounting - Discrepancy?	Lost4Now	General Discussion	3	February 5th, 2006 05:10 PM
Conditional Format Not Working	KMH	General Discussion	0	December 22nd, 2005 05:32 PM
How do you get parentheses to auto format in phone number?	Tijil	Contacts	3	December 15th, 2005 09:42 AM
Accounting format now no longer display negative figures in ( )'s	R. Earl R.	General Discussion	2	October 16th, 2005 09:56 PM