Scenario:
A1 value is "3/31/08"
In column C15, I type the formula, '="For the month ending "&A1'.

Problem:
It used to return, 'For the month ending 3/31/08'. Now it returns 'For the
month ending 39538'. I've tried changing the formatting and does not work.
I tried other formulas for the date but still returns the MS serial number.

Any help will be appreciated.

Marco