Formatting (1.6%) but don't want it to be red

Dallas CPA

New Member
Joined
Apr 8, 2011
Messages
1
Okay this should be simple, but it doesn't appear to be possible through regular formatting.

I have a spreadsheet of percentages, with one digit after the decimal sign. I would like negative percentages to be displayed as (1.6%) instead of -1.6%. But only way to accomplish this is to have it displayed as red, which I do not want. Anybody know how to get the desired result ?

Many thanks. Glad I found this board, look forward to becoming an active user.
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

MrKowz

Well-known Member
Joined
Jun 30, 2008
Messages
6,653
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Welcome to the forums!

Apply the following custom number format:

0.0%;(0.0%)
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,770
Office Version
  1. 2010
Platform
  1. Windows
Or _(0.0%_);(0.0%) so the symbols align.
 

BradA

Board Regular
Joined
Sep 24, 2010
Messages
75
Or _(0.0%_);(0.0%) so the symbols align.

This is awesome, but will you explain it to me? Don't the parenthesis in what you posted make the entry appear in parenthesis? I tried it and I see that it works but I guess I don't understand what's going on with that format.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,320
Messages
5,527,996
Members
409,798
Latest member
Snake68

This Week's Hot Topics

Top