Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |