Remember Me?

#### Menu

#1
September 15th 05, 06:18 PM
 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
September 15th 05, 06:33 PM
 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
September 15th 05, 06:35 PM
 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.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 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 11:32 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.

# About Us

"It's about Microsoft Excel"

Copyright © 2017