PC Review


Reply
Thread Tools Rate Thread

Accounting Format Parentheses

 
 
=?Utf-8?B?dGlnZ3ky?=
Guest
Posts: n/a
 
      24th Jul 2006
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 With Quote
 
 
 
 
David McRitchie
Guest
Posts: n/a
 
      30th Jul 2006
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" <(E-Mail Removed)> wrote in message news:C0962645-6953-4F0B-9891-(E-Mail Removed)...
> 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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I set up format for phone numbers, parentheses vs dashes Hankyc Microsoft Outlook Contacts 2 10th Nov 2008 04:11 AM
Format negatives with parentheses Joe Microsoft C# .NET 2 9th Aug 2006 07:57 PM
Show parentheses in Accounting Format =?Utf-8?B?dGlnZ3ky?= Microsoft Excel Discussion 4 25th Jul 2006 05:42 AM
How do you get parentheses to auto format in phone number? =?Utf-8?B?VGlqaWw=?= Microsoft Outlook Contacts 3 15th Dec 2005 09:42 AM
format numbers with parentheses Rob Microsoft Dot NET 0 5th Nov 2003 08:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:04 PM.