Convert Date to Text?

[Mike D.]

Hi. Is there a way to convert a date value to text? For
instance, in cell A1 I have the date 6/24/04 in the cell.
If I change the format of the cell to "Text" the number
38162 appears. I would actually like to covert this to be
6/24 but as text, not as a date ...

Thanks,
Mike.

 

[Andy B]

Hi

Excel dates and times are stored as numbers (as you now know!). One way to
get what you want is with a helper column alongside your existing data. In
this, type:
=TEXT(A2,"mm/dd")
This should give you what you want. You can AutoFill this down. To fix these
values (so that they don't rely on the other column) select the range, Copy,
Paste Special. . . Values.

 

[Mike D.]

Andy:

Thanks for your help! I've got a macro creating the
chart, so I can include this in the macro.

Mike.

 

[Guest]

You could download the third party tool: AddinTools Assist from
http://www.addintools.com. It include several functions. One of these
functions is convert data of cells to text/number/date-time type.
It can convert data of all formats to text type.
It can recognize these formats as following and convert to date-time type:
2003.1.2, 2003.1.2 11:12:13:14PM, 2003-1-2, 2003-1-2 11:12:13.14PM,
20030102, 20030102 11:12:13:14PM, and locale format on your computer, and so
on …
It can recognize these formats as following and convert to number type:
1,234.56, -1,234.56, (1,234.56)
$1,234.56, $-1,234.56, ($1,234.56), -$1,234.56
$1.23E2, -$1.23, -$1,234.56
123%, -123%, (123%), (123)%
1.23E2, -1.23E2, (1.23E2), (1.23)E2