question about "Monthname"

[Excelboo2]

normally monthname(1)="Jan" but since my office is chinese version so monthname(1) will give me the chinese name of Jan. What can I do if I want to have "Jan" instead of chinese name of "Jan". Thanks

 

[Andrew Poulsom]

Maybe something like:

   Dim MthNo As Integer
   Dim MthUK as String
   MthNo = 1
   MthUK = Choose(MthNo,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")
   MsgBox MthUK

 

[Excelboo2]

Maybe something like:

   Dim MthNo As Integer
   Dim MthUK as String
   MthNo = 1
   MthUK = Choose(MthNo,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")
   MsgBox MthUK

that means I can't use "monthname" anymore . Thanks