[Hi

Need some much needed help with a fomrula that basically combines "text" with values in specific cells within the spreadsheet.

I trying to combine following to return a date but the date (14-jan) from cell A15 always returns a serial number and not dd-mmm-yy formating.


String formula
="Below represents data taken on" & A15

Returns[/U][/B]

Below represents data taken on 40192

Expecting

Below represents data taken on 14 January 2010