0s in =if function are being deleted

[sverre123]

i have used a =mid function to get birth months out of personal numbers from a column. Now i want to use an =if function to convert these numbers into quarters of a year (so that month 01-03 gets a quarter value 1, 04-06 gets 2 and so on. The problem is that my if function is automatically transformed from =if(f2=01;"1"..) to if(f2=1;"1"..). It deletes the 0 in front of the number. So now the =if function in the quarter column doesnt recognise the values with 0 in front of them in the birthmonth column. I dont know how to format away this zero in front of the birthmonth or how to keep the 0s in the =if function. Do anyone have a solution to this? Thank you very much in advance!

[dilipandey]

Hi sverre123,

You have data numbers as 01,02 denoting months.. are you sure these are numbers ?
Because your formula dont need to have 01 as 01 OR 1 are treated same in formulas.
In case of any issues, please upload a sample workbook.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[JosephP]

probably
=if(f2="01";"1"..)