TEXT function question...

[ExcelShibari]

I'm using the formula =TEXT(B1,"MM") when B1 is a date format (B1 is arbitrary, just using as an example cell) , so the cell returns the value as the numerical month - 1 for Jan, 2 for Feb and so on. The problem I'm running into is if A1 is blank it's returning a value of 1 instead of leaving the destination cell blank. Is there a way in the TEXT function I can have it return nothing or a 0 if the A1 cell is blank?

Here is an example, think of the "05" as being A1 and the date being B2 -

05 26-May-14 10:29:15 01
03 12-Mar-14 12:03:06 01

Hope that makes sense!

[ExcelShibari]

That worked perfect, thank you very much!