[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
="Below represents data taken on" & TEXT(A15,"dd mm yyyy")
Last edited by Palmetto; 01-14-2010 at 02:54 PM.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
You need to use TEXT function like this
="Below represents data taken on" & TEXT(A15,"d mmmm yyyy")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks