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