question about "Monthname"

Excelboo2

Board Regular
Joined
Oct 11, 2006
Messages
175
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
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Maybe something like:

Code:
   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

Board Regular
Joined
Oct 11, 2006
Messages
175
Maybe something like:

Code:
   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 :cry: . Thanks :biggrin:
 

Watch MrExcel Video

Forum statistics

Threads
1,109,026
Messages
5,526,325
Members
409,696
Latest member
EERS

This Week's Hot Topics

Top