Remember Me?

#1
 David Iacoponi Posts: n/a
Formatting a number to look like a Percent without a percent sign

We often want a column of decimals to have a percent sign only on the first
number in the column, so:
..553
..554
(.345)
need to be formatted to look like
55.3%
55.4
(34.5)
where all the decimals align vertically. I can't figure out how to do this
without multiplying the second and third cells by 100, which is a bad
solution.

Any ideas? Thanks.
#2
 Mike Posts: n/a

format custom 0.0

"David Iacoponi" wrote:

We often want a column of decimals to have a percent sign only on the first
number in the column, so:
.553
.554
(.345)
need to be formatted to look like
55.3%
55.4
(34.5)
where all the decimals align vertically. I can't figure out how to do this
without multiplying the second and third cells by 100, which is a bad
solution.

Any ideas? Thanks.

#3
 Mike Posts: n/a

And by the way, multiplying by 100 is the only solution for what you want.

"David Iacoponi" wrote:

We often want a column of decimals to have a percent sign only on the first
number in the column, so:
.553
.554
(.345)
need to be formatted to look like
55.3%
55.4
(34.5)
where all the decimals align vertically. I can't figure out how to do this
without multiplying the second and third cells by 100, which is a bad
solution.

Any ideas? Thanks.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Alicia Rittenhouse Excel Discussion (Misc queries) 1 August 25th 05 10:27 PM MickF Excel Worksheet Functions 2 May 19th 05 07:18 PM Gregg Riemer Excel Discussion (Misc queries) 1 January 4th 05 10:53 PM [email protected] Excel Discussion (Misc queries) 7 December 20th 04 10:23 PM msmiller613 Charts and Charting in Excel 1 December 15th 04 03:47 AM

All times are GMT +1. The time now is 04:05 AM.