I am trying to keep formatting between cell references.

For instance, I have a date in once cell (J9) and would like to add this date to a text field so e.g.:

="This will take effect on " & J9 & "."

However, when I do this, I end up with numbers...

"This will take effect on 172543."

I have googled for quite a while now, and tried many built in functions, including left, right, concatenate, datevalue, etc. etc. etc. and cannot find a solution for how to do this in a cell formula.

Any ideas?

solved... I used another reference cell...

Which returns (for today) "26 January 2009".
I can then reference this cell elsewhere.