> >I have a large table in word. Every item in every cell needs to have a
> >percentage sign after it.
[quoted text clipped - 12 lines]
> Email cannot be acknowledged; please post all follow-ups to the
> newsgroup so all may benefit.
If you have an existing table to convert, copy the table first with yr
current numbers to Excel. Then a second table, mimicking the first in
size and format, but with a formula where you divide the cell contents
of yr first cell by 100, and format as %. Copy the formulas to the
other cells. You can also apply a standard factor to the cell format.
Copy this converted table back into Word.
You may also use Find/replace in Word directly, if the cell numbers end
with a pilcrow. Select the table cells, and replace ^p (^p represents
the pilcrow) by %^p.
If the cells do not end w/ a pilcrow, for that matter, you can convert
the table to text, separating the cells by a paragraph mark (the
pilcrow), do the find/replace as above, and convert back to the table.
But this needs some forward thinking as also some existing pilcrows
maybe converted unintendedly. You may need some intermediary steps,
e.g. convert the pilcrows you dont want to convert to %+pilcrow into a
unique character, and reverse it afterward.
Hope this is not too complicated.
Henk
Betsy;2340205 Wrote:
> I thought of this, however when you paste the table into Excel and
> change the
[quoted text clipped - 25 lines]
> newsgroup so all may benefit.
> -

Signature
Henk57
Betsy - 30 Aug 2007 12:26 GMT
Thanks for all your help!
> If you have an existing table to convert, copy the table first with yr
> current numbers to Excel. Then a second table, mimicking the first in
[quoted text clipped - 49 lines]
> > newsgroup so all may benefit.
> > -