Special characters

We collect data from a form available on the Internet. This form stores the
submitted data into a .csv file. When we open this file with Excel (Excel
2004 v. 11.1 for Mac) the European special characters shows as different
symbols. The characters display nicely in the .csv file itself. When opening
the same file on a PC running Open Office there's an option to choose what
character set we want to use when importing the .csv file. Open Office
suggest using "Western Europe (Windows-1252/WinLatin 1)" which works
perfectly. But I need it to work with a Mac running OS-X. I can't find any
place to change the character set used when importing the file to Excel
running on Mac.

I don't know how this will display on everyone's screens, but here's
examples on some of the characters: "æ", "ø", "å". (There's only one
character within each "").

A solution to the problem, if no-one has any better suggestion, could
perhaps be to make a command to change whatever symbols (different
characters put together) that replaces the original character in all of the
document after it is imported. I have very little experience using MS Office
and don't know if that's even possible to make a "command" like this, - or
if it is possible, how to do it. This is a document meant to be updated and
imported daily.

Anyone have any suggestions on how to make it work? Or any ideas where to
ask?
Thanks,
--
T.