I think I've found a glitch in excel that I would like to manipulate. I have found that if I put the number "444" in a cell, Excel will convert this to the month name "March" using customer formatting. When excel looks to the 444 number and I ask for "mmmm" it displays the month ...
I am trying to write a "IF" test to do the following: If the value of A1 = 1, then cell = B1 If the value of A1 = 2, then cell = B2 If the value of A1 = 3, then cell = B3