Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to align text around a symbol???
Hi all, I am trying to align a table of data that looks like this: 15.8 ± 3.3% 13.5 ± 1.4% 2.9 ± 3.3% 11.1 ± 0.0 6.5 ± 4.7 50.0 ± 29.6 146.8 ± 0.0 0.4 ± 0.0% They are formatted as text. Not all get the percent symbol. I'd like to align the ± symbols to tidy the appearance of the data. Suggestions? Actually, the whole thing looks more like this (here's a sample with three data columns that spans two sampling dates Note the non-data rows) Spring 2004 Data Type Box Woodlot Fernwood Number of Quadrats Invaded 18.0 20.0 Total A. petolata Cover (%) 19.7 ± 2.1% 50.0 ± 5.5% Adult Cover (%) 3.4 ± 3.7% 16.0 ± 7.5% Seedling Cover (%) 16.3 ± 4.6% 34.8 ± 4.3% Seedings/0.5m2 88.0 ± 0.0 74.4 ± 0.0 Adults/0.5m2 2.8 ± 4.6 12.7 ± 3.1 Mean A. petiolata Height 16.5 ± 30.2 55.8 ± 52.8 Per Capita Fecundity 56.8 ± 0.0 228.6 ± 0.0 Leaf Damage (% removed) 0.9 ± 0.0% 0.6 ± 0.0% Damage Types (% of Quadrats) Windowpane Damage 0 0 Edge Feeding Damage 0.9 ± 0.1% 0.4 ± 0.1% Holes Damage 0.9 ± 0.1% 0.9 ± 0.1% Disease Damage 0.1 ± 0.0% 0.2 ± 0.0% Other Damage 0 0 Soil Cover (%) 35.0 ± 5.1 11.5 ± 1.4 Wood Cover (%) 29.8 ± 4.8 7.4 ± 3.9 Leaf Cover (%) 35.3 ± 0.0 81.1 ± 0.1 Rock Cover (%) 0 0.1 ± 0.2 Spring 2005 Data Type Box Woodlot Fernwood Number of Quadrats Invaded 19 20 Total A. petolata Cover (%) 12.3 ± 2.9% 37.7 ± 1.6% Adult Cover (%) 10.0 ± 1.0% 5.6 ± 6.2% Cheers, Jeff -- guillemot ------------------------------------------------------------------------ guillemot's Profile: http://www.excelforum.com/member.php...o&userid=29833 View this thread: http://www.excelforum.com/showthread...hreadid=501818 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked cells and text boxes | Excel Discussion (Misc queries) | |||
Text Wrapping | Excel Discussion (Misc queries) | |||
SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |