Is there a way I can get Excel to recognize characters not used in American English? When I export my collection, my spreadsheet has difficulties with some of the words. Is there some way that I can update my excel to recognize other alphabets?
Thanks
Excel Spreadsheet and Different Alphabets
Pubblicazioni di 11
» Accesso rapido all'ultima pubblicazione
Pubblicato:
#
Not what I know of. The biggest problem is the North African and Middle East coins. We've been nagging about this for months.. 
Pubblicato:
#
Here is what you can do. It requires that you have a text editor that supports regular expressions (for example, Notepad++), but it will give you the correct characters instead of all those HTML &#nnn; codes.
Voila:
- Open the spreadsheet in Excel.
- Select the D column
- Copy
- Now, open a text editor that supports regular expressions
- Paste
- Replace $ (end of line) with <br>. Your file should then look like this:
- Save the file as x.htm
- Open x.htm in your web browser
- Hit Ctrl-A to select the entire file, copy
- Go back to your Excel file, click on the I1 cell, paste, and save.
Voila:
HoH
Pubblicato:
#
Lol @ Houseofham! 
You still haven't solved it. It still says "Sant ī ;m ā ;t" instead of either "Santimat" or "Santīmāt"
You still haven't solved it. It still says "Sant ī ;m ā ;t" instead of either "Santimat" or "Santīmāt"
Pubblicato:
#
Cita: "Houseofham"The D column has not changed. The "fixed" descriptions are in column I. I'm sure people are more than capable of cutting and pasting from one column to another, if they no longer need the original "broken" descriptions. ^^Ah! I didn't even see the I column.
Pubblicato:
#
Cita: "Houseofham"The D column has not changed. The "fixed" descriptions are in column I. I'm sure people are more than capable of cutting and pasting from one column to another, if they no longer need the original "broken" descriptions. ^^PEBKAC
Just kidding. ^^
Very nice & easy patch for the problem!
Il fuso orario utilizzato è UTC+2:00.
L'ora attuale è 14:59.