Formatting a negative percent

trishnaha · May 16th, 2002, 10:12 AM

I am preparing a financial statement in Excel and am working with percentages. The only problem I have is I want the percent to read (1.19)% but cannot format this. I keep getting -(1.19)% - How do I get rid of the minus sign.

paulyf · May 16th, 2002, 10:15 AM

Hi

Within Format->Cells->Custom

Choose 0.00% and change to:

0.00%;(0.00%)

Cheers - Paul

NateO · May 16th, 2002, 10:16 AM

Format your number as described here:

http://www.mrexcel.com/board/viewtop...c=8453&forum=2

trishnaha · May 17th, 2002, 11:18 AM

Quote:

Thank you. I took me forever and this did work. Right on!
On 2002-05-16 09:15, paulyf wrote:
Hi

Within Format->Cells->Custom

Choose 0.00% and change to:

0.00%;(0.00%)

Cheers - Paul

May 16th, 2002, 10:16 AM	#3
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Format your number as described here: http://www.mrexcel.com/board/viewtop...c=8453&forum=2 __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

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

May 16th, 2002, 10:12 AM	#1
trishnaha New Member Join Date: May 2002 Posts: 5	I am preparing a financial statement in Excel and am working with percentages. The only problem I have is I want the percent to read (1.19)% but cannot format this. I keep getting -(1.19)% - How do I get rid of the minus sign.

May 16th, 2002, 10:15 AM	#2
paulyf New Member Join Date: Mar 2002 Location: Paul Posts: 34	Hi Within Format->Cells->Custom Choose 0.00% and change to: 0.00%;(0.00%) Cheers - Paul