stop automation to date field
I have formatted cell A1 to be Custom category, type dd-mm. Then I typed in
1-12 and cell A1 displays 01-12. However, in the formula (fx) bar, it shows
01/12/2006. I don't want A1 to contain /2006 as I want to concatenate this
with another cell containing the text "/2007" and other year values. How can
I do this?
Thanks!
|