combining a linked date with text

swagman · Apr 26th, 2002, 09:09 AM

I am trying to link a date value into a cell that also has text. When I do this, the date value converts a #. My formula looks like this: (where A1 is a date)
="as of :"&A1
I've also tried using the text function to convert the # back to a date, like this:
="as of "&TEXT(A1,"date")
But this returns "as of 31at2002".

The only way I can get the date to look like a date is to put it in its own cell, but this doesn't look smooth.

Ricky Morris · Apr 26th, 2002, 09:44 AM

Try this:

="as of : "&TEXT(A1, "mmmm dd, yyyy")

swagman · Apr 26th, 2002, 09:48 AM

Excellent!

Thank you

Apr 26th, 2002, 09:44 AM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Try this: ="as of : "&TEXT(A1, "mmmm dd, yyyy") __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 09:09 AM	#1
swagman New Member Join Date: Apr 2002 Posts: 6	I am trying to link a date value into a cell that also has text. When I do this, the date value converts a #. My formula looks like this: (where A1 is a date) ="as of :"&A1 I've also tried using the text function to convert the # back to a date, like this: ="as of "&TEXT(A1,"date") But this returns "as of 31at2002". The only way I can get the date to look like a date is to put it in its own cell, but this doesn't look smooth.

Apr 26th, 2002, 09:48 AM	#3
swagman New Member Join Date: Apr 2002 Posts: 6	Excellent! Thank you