Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 15th 05, 06:18 PM
David Iacoponi
 
Posts: n/a
Default 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   Report Post  
Old September 15th 05, 06:33 PM
Mike
 
Posts: n/a
Default

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   Report Post  
Old September 15th 05, 06:35 PM
Mike
 
Posts: n/a
Default

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Number formatting when importing from Access to Excel Alicia Rittenhouse Excel Discussion (Misc queries) 1 August 25th 05 10:27 PM
Clean does not remove hidden formatting on a number MickF Excel Worksheet Functions 2 May 19th 05 07:18 PM
Pivot Table Drill Down Number Formatting Gregg Riemer Excel Discussion (Misc queries) 1 January 4th 05 10:53 PM
Conditional Formatting (Date vs Number) [email protected] Excel Discussion (Misc queries) 7 December 20th 04 10:23 PM
Is there a way to have two values (percent and number) in a label. 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