Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Improve Convert function in Excel | Excel Worksheet Functions | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions |