Converting NumberFormatLocal to NumberFormat

C

Charlotte E.

Hi Guys,


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

And, currently, I'm using a cell as 'middleman' :)

Range("A1").NumberFormatLocal = Local_Format_Name
English_Format_Name = Range("A1").NumberFormat

Is it possible to do this convert without using a worksheet at all?


CE
 
C

Claus Busch

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.
Click to expand...

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.
 
C

Charlotte E.

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

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



CE
 
H

Harald Staff

Hi Charlotte

VBA is not very helpful when it comes to regional settings. Afaik no, the
way, at least the fast and easy way, to do this is through the worksheet
interface.

Best wishes Harald

Charlotte E. said:
Thanks, Claus, but that does just what I'm already doing...

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



CE
Click to expand...
 
C

Charlotte E.

Thanks, Harald,

I'll continue to use my 'worksheet way'.

At least I did it the right way for once :)


CE


Harald Staff said:
Hi Charlotte

VBA is not very helpful when it comes to regional settings. Afaik no, the
way, at least the fast and easy way, to do this is through the worksheet
interface.

Best wishes Harald
Click to expand...
 
Top