Hi
Sorry if this has long since been discussed and solved, but sadly in searching the forum and the web, I can't find a solution! doh!
I guess the fact I'm in the UK might be relevant to code pages etc

I'm reading in (well cut and pasting from a text file, generated by a dos piped dir command) a list of file names that have £, $ and € currencies within the file name
The $ symbol are fine as excel retains the symbol with no hassle
The £ symbol becomes œ (char 156), so I can use "substitute" to convert to char 163
The € symbol becomes a standard ? (char 63) so this can be changed to char 128 as "?" are not used in the file names, so no chance of extra € appearing!

SUBSTITUTE(SUBSTITUTE(C2,char(156),CHAR(163)),CHAR(63),CHAR(128))

So reading in is fine, but then I need to write it back, as it will become a batch file of rename commands (yes, I could write some VBA rather than creating a batch file, but this is a quick and dirty project - or was quick till I hit this brick wall !)

So for the £ values I use the following to reformat them to work in the batch file, and it works fine

TEXT(VALUE(AO2),CHAR(156)&"0.00")

Sadly the EURO (€) cannot be written as char 63 "?", and I have tried char 250 and char 128, but none work ...

Is there are char that will work, if not can this be done in VBA, if so what char should I use?

Everything else is fine, just the pesky EURO! ... and no I'm not joining UKIP to avoid the issue :-)

thanks in advance