Displaying month or year as text
Using Excel 2007. I have a date of 15-Aug-09 in a cell but if I use the
function Text(Month(cell),"mmm") it shows "Jan". If I try with the Year
function I get "1905". Entering just Month(cell) gives me the correct answer
of "8". What is wrong please?
|