Dates as text
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?
|