[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
Bookmarks