using a formula, I am combining a column heading and the date in that row, so
that the cell will read "Column Heading Date", but the date is showing as a
number rather than a date. I want the cell to contain both txt (column
heading), and a date. How do I format it to do so?

assuming your date is in cell A1:

="heading text "&DAY(A1)&"/"&MONTH(A1)&"/"&YEAR(A1)
--
hope to help,
cm


"lightbulb" wrote:

using a formula, I am combining a column heading and the date in that row, so
that the cell will read "Column Heading Date", but the date is showing as a
number rather than a date. I want the cell to contain both txt (column
heading), and a date. How do I format it to do so?

Hi

Try this:

=A1 & " " & TEXT(A3,dd.mm.yy")

where date is in A3

Hopes this helps.
....
Per

"lightbulb" skrev i meddelelsen
...
using a formula, I am combining a column heading and the date in that row,
so
that the cell will read "Column Heading Date", but the date is showing as
a
number rather than a date. I want the cell to contain both txt (column
heading), and a date. How do I format it to do so?

Or, simpler,

="Heading test"&TEXT(A1,"dd/mm/yyyy")

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]


On Mon, 21 Dec 2009 12:20:01 -0800, cm
wrote:

assuming your date is in cell A1:

="heading text "&DAY(A1)&"/"&MONTH(A1)&"/"&YEAR(A1)

This is close....for example my date is 05/01/2010, and after the formula, it
reads 1/5/2010....further help?


"cm" wrote:

assuming your date is in cell A1:

="heading text "&DAY(A1)&"/"&MONTH(A1)&"/"&YEAR(A1)
--
hope to help,
cm


"lightbulb" wrote:

using a formula, I am combining a column heading and the date in that row, so
that the cell will read "Column Heading Date", but the date is showing as a
number rather than a date. I want the cell to contain both txt (column
heading), and a date. How do I format it to do so?

switch places with the day and month:

="text "&MONTH(A1)&"/"&DAY(A1)&"/"&YEAR(A1)

--
hope to help,
cm


"lightbulb" wrote:

This is close....for example my date is 05/01/2010, and after the formula, it
reads 1/5/2010....further help?


"cm" wrote:

assuming your date is in cell A1:

="heading text "&DAY(A1)&"/"&MONTH(A1)&"/"&YEAR(A1)
--
hope to help,
cm


"lightbulb" wrote:

using a formula, I am combining a column heading and the date in that row, so
that the cell will read "Column Heading Date", but the date is showing as a
number rather than a date. I want the cell to contain both txt (column
heading), and a date. How do I format it to do so?

Or shorter,
="text "&Text(a1,"mm/dd/yyyy")

Regards,
Fred


"cm" wrote in message
...
switch places with the day and month:

="text "&MONTH(A1)&"/"&DAY(A1)&"/"&YEAR(A1)

--
hope to help,
cm


"lightbulb" wrote:

This is close....for example my date is 05/01/2010, and after the
formula, it
reads 1/5/2010....further help?


"cm" wrote:

assuming your date is in cell A1:

="heading text "&DAY(A1)&"/"&MONTH(A1)&"/"&YEAR(A1)
--
hope to help,
cm


"lightbulb" wrote:

using a formula, I am combining a column heading and the date in that
row, so
that the cell will read "Column Heading Date", but the date is
showing as a
number rather than a date. I want the cell to contain both txt
(column
heading), and a date. How do I format it to do so?

="Column Heading " & TEXT(A1,"mm-dd-yyyy")


Gord Dibben MS Excel MVP


On Mon, 21 Dec 2009 12:16:01 -0800, lightbulb
wrote:

using a formula, I am combining a column heading and the date in that row, so
that the cell will read "Column Heading Date", but the date is showing as a
number rather than a date. I want the cell to contain both txt (column
heading), and a date. How do I format it to do so?