Thanks, Claus, but that does just what I'm already doing...

....I wanted to avoid using a cell in the process.



CE


"Claus Busch" wrote in message
...
Hallo Charlotte,

Am Sat, 5 Oct 2013 17:10:00 +0200 schrieb Charlotte E.:

I need to convert strings containing local numberformats into English
numberformats.

I use this function to translate local formulas to into english
formulas. That will also convert the numberformat.
Your string in A1 then call the function into the sheet with
=English(A1)

Function English(rngC As Range) As String
English = rngC.Formula
End Function


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2