getting unicode to convert from PC to MAC
 

I have all my data in Mysql, which supports Unicode. When I look at the data
on my MAC all the Registermarks, Trademarks ect. look just fine. I then have
to export my data, which instantly opens into Excel (on my MAC) and I get
lots of crazy characters instead of my Trademarks, Reg., M-dashs....even my
apostrophes show up as a strange character instead of an apostrophe. I have
to search and replace all of the characters to what they should be (again and
again, everytime I need to update my pages).
What can I set as a preference or trigger to receive what I see in the system?

If you have MacXL2004, you shouldn't have to do anything. If you have a
previous version, you'll need to upgrade, previous versions didn't have
full Unicode support.

In article ,
"not a programmer" <not a wrote:

I have all my data in Mysql, which supports Unicode. When I look at the data
on my MAC all the Registermarks, Trademarks ect. look just fine. I then have
to export my data, which instantly opens into Excel (on my MAC) and I get
lots of crazy characters instead of my Trademarks, Reg., M-dashs....even my
apostrophes show up as a strange character instead of an apostrophe. I have
to search and replace all of the characters to what they should be (again and
again, everytime I need to update my pages).
What can I set as a preference or trigger to receive what I see in the system?

Unfortunately that wasn't the answer. I am very current on our XL2004. I know
there are languages you can set, do you know what the perferred ones should
be?

"JE McGimpsey" wrote:

If you have MacXL2004, you shouldn't have to do anything. If you have a
previous version, you'll need to upgrade, previous versions didn't have
full Unicode support.

In article ,
"not a programmer" <not a wrote:

I have all my data in Mysql, which supports Unicode. When I look at the data
on my MAC all the Registermarks, Trademarks ect. look just fine. I then have
to export my data, which instantly opens into Excel (on my MAC) and I get
lots of crazy characters instead of my Trademarks, Reg., M-dashs....even my
apostrophes show up as a strange character instead of an apostrophe. I have
to search and replace all of the characters to what they should be (again and
again, everytime I need to update my pages).
What can I set as a preference or trigger to receive what I see in the system?

Then I would use Font Book to check which fonts are active. Office comes
with 4 full Unicode fonts (including Symbol, Arial and Times New Roman)
that it puts in your ~:Library:Fonts folder. Make sure you aren't using
a different font version. Older versions of Symbol have been a problem
occasionally reported in the microsoft.public.mac.office* newsgroups.

In article ,
"not a programmer" wrote:

Unfortunately that wasn't the answer. I am very current on our XL2004. I know
there are languages you can set, do you know what the perferred ones should
be?