Extract the MONTH of a cell value with Excel VBA

[trizzo]

Hello everyone!

On B5 cell, I have the following value: 2015-04-01 , so it is in DATE format.

I want to get the value 04 exactly as 04 , but it is returning 4! I should get 04, with zero!

Here is what I tried:

Please Login or Register  to view this content.

Even using the following, it is not working:

Please Login or Register  to view this content.

This must be Integer or Long.

Can anyone help me, please?

Thanks!

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[trizzo]

Thanks for quick response John! Ok, but, it is a Variant variable which shows "04" what if I need to get that as Integer or Long? 04 instead of "04".

[Arkadi]

Dim as long instead of variant, though it will drop the leading 0. You can format how it is displayed, but not the actual value (length) of the variable.

Assuming you are pasting it somewhere, or displaying in a message, then you could msgbox format(MonthHistory,"00")

[JOHN H. DAVIS]

What do you intend too do with the variable?

[trizzo]

Sorry Guys, the solution provided by John worked great, I am actually using a number without 0 in front of it now.
Thanks everyone for all your help!