Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lining up cells with % symbol to those without.
Hello,
I am trying to create a table that lists the weights of categories as a % of the total. The problem is I need the table formatted so that the first category reads xx.x%, while all the remaining categories read xx.x (still a percent but not displaying the percent sign). I also need a total at the bottom of the list to sum the percents (i can cheat and do this a different way) that should read xx.x%.. See below for example. 25.3% 22.3 2.3 50.1 100.0% The goal is to not have the % symbol on the middle lines and have the decimals line up. Thanks, Brady |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lining up cells with % symbol to those without.
Select the middle cells (those without %)
Use Format | Cells - Custom and make the format General" " I got good results with 5 spaces between the double quotes. Also note the cell values still behave as numeric values. Be careful though: the top value is 0.253 while the second one is 22.3 You will need to compensate for this in all formulas as in =A1+SUM(A2:A4)/100 to get the correct sum best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "landrybj" wrote in message ... Hello, I am trying to create a table that lists the weights of categories as a % of the total. The problem is I need the table formatted so that the first category reads xx.x%, while all the remaining categories read xx.x (still a percent but not displaying the percent sign). I also need a total at the bottom of the list to sum the percents (i can cheat and do this a different way) that should read xx.x%.. See below for example. 25.3% 22.3 2.3 50.1 100.0% The goal is to not have the % symbol on the middle lines and have the decimals line up. Thanks, Brady |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lining up cells with % symbol to those without.
Use a custom format of 0.0_%
The underscore tells Excel to reserve space for the % sign even though it's not displayed. This feature is most commonly used in accounting format where negative numbers are shown in brackets, but you want positive numbers to line up under the decimal point. However, it works equally well with a percent sign. -- Regards, Fred "landrybj" wrote in message ... Hello, I am trying to create a table that lists the weights of categories as a % of the total. The problem is I need the table formatted so that the first category reads xx.x%, while all the remaining categories read xx.x (still a percent but not displaying the percent sign). I also need a total at the bottom of the list to sum the percents (i can cheat and do this a different way) that should read xx.x%.. See below for example. 25.3% 22.3 2.3 50.1 100.0% The goal is to not have the % symbol on the middle lines and have the decimals line up. Thanks, Brady |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lining up cells with % symbol to those without.
One learns something everyday!
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Fred Smith" wrote in message ... Use a custom format of 0.0_% The underscore tells Excel to reserve space for the % sign even though it's not displayed. This feature is most commonly used in accounting format where negative numbers are shown in brackets, but you want positive numbers to line up under the decimal point. However, it works equally well with a percent sign. -- Regards, Fred "landrybj" wrote in message ... Hello, I am trying to create a table that lists the weights of categories as a % of the total. The problem is I need the table formatted so that the first category reads xx.x%, while all the remaining categories read xx.x (still a percent but not displaying the percent sign). I also need a total at the bottom of the list to sum the percents (i can cheat and do this a different way) that should read xx.x%.. See below for example. 25.3% 22.3 2.3 50.1 100.0% The goal is to not have the % symbol on the middle lines and have the decimals line up. Thanks, Brady |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find a certain symbol in cells? | Excel Discussion (Misc queries) | |||
remove percent symbol on percentage formatted cells in excel | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |