Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
killing accents sos
Hi,
I'm working on a French system with Excel and text files I copy and paste from and to text files opened from within excel If I "paste" a value from the text file into excel like this : range("a1").value = then i loose the accents (they're actually transformed like "é" in "Ú" (providing you can read this) If I paste something i got from the texte file using selection.copy then it gets through. More curious, if I make my selection (from Excel to Txt this time) like this with sheets(...) range(...).copy and then paste PasteSpecial xlPasteValues I also loose accents while a sheets(...).select will keep the accents ! Any idea how i could always keep those damned accents ? Thanks Philippe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do you know any formula to delete accents? | Excel Worksheet Functions | |||
How does one apply letters with accents | Excel Discussion (Misc queries) | |||
Language accents | Excel Programming | |||
french accents in excel | Excel Worksheet Functions | |||
add accents to text | Excel Discussion (Misc queries) |