View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Melissa Melissa is offline
external usenet poster
 
Posts: 122
Default 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!