After much trial and error, I figured out a way to insert a degree symbol
that would merge successfully from an excel file to a word merge document in
2000.
I also discovered that not all "symbols" are created equal, in that some of
them DO make the transition during a merge, while others don't (!)
If the "superscript 0" is used, instead of the actual degree symbol, it
will merge successfully! However, the superscript 0 cannot be inserted using
the numeric keypad (alt-0186), but must first be inserted into a Word
document, then copied and pasted into the excel spreadsheet formula.
Wolla!
Peter Jamieson - 08 Apr 2005 10:40 GMT
Well researched!
I have to say I am able to insert a superscript 0 using Alt 0186 here. But
in Excel you could consider using the Windows Character Map (by default,
under Start|Programs|Accessories|System Tools) to select and enter the
character. The Character Map isn't installed by default so you might need to
go to the Control Panel|Add/Remove software to install it. I don't know if
there is a better way to do it - you might try an Excel newsgroup.
Peter Jamieson
> After much trial and error, I figured out a way to insert a degree symbol
> that would merge successfully from an excel file to a word merge document
[quoted text clipped - 12 lines]
>
> Wolla!
Frustrated - 08 Apr 2005 14:33 GMT
Thanks, Peter. I did try looking up the Character Map in Excel, but as you
mentioned, it had not been downloaded. I would have to go through my IT
center to get that accomplished, so I resorted to other tactics.
I also tried the "file conversion" on merging the excel file, but that only
gave me compressed data that was totally illegible.
Still, I appreciate your help and am glad I found this newsgroup!
> Well researched!
>
[quoted text clipped - 22 lines]
> >
> > Wolla!