Convert month name to 2 digits

[seanpears99]

Hi all

Searched for 2 hours yesterday and came up dry.

I need to convert January, February, etc to 01, 02 (2 digits), I can get single digits but not double.

Can anyone assist?

Thanks
Sean

[rollis13]

You can format the cell with Number/Custom: 00 (double zero)

[seanpears99]

Hi

Thanks but I need to amend it through a variable.

[rollis13]

If you explain what your doing and show how you are trying to do it maybe someone else could be of some help.

[Special-K]

Please Login or Register  to view this content.

Source: http://stackoverflow.com/questions/1...me-into-number

[seanpears99]

I need to convert the name of the month to a corresponding number, i.e. January will be 01, but I need the leading 0

[seanpears99]

Special-K = Legend

Thank u

[crosservice]

To use the following function in your code just use something like:

activesheet.range("A1").value = convert_month("January")

This will return the string "01" which you can work with. Anyway, unless someone is actually typing in the month in this text-type way, you're better off using a formula like the following:

=IF(MONTH(A1)<10,CONCATENATE(0,MONTH(A1)),MONTH(A1))

Where "A1" is the range with an actual date in it.

Please Login or Register  to view this content.

Sorry if this reply is a little cluttered.

Moderators note: code tags added for you - this time

[shg]

There are surely 100 ways to do this.

Please Login or Register  to view this content.

[FDibbins]

@ crosservice, welcome to the forum

when you post VBA code, please use code tags, it makes it easier to read and understand - see my notes below on how to use them