Date to Text conversion

[Mark]

How do you convert a date value to a text value? The only
way that I am aware to accomplish this feat is to manually
insert a "'" in front of the data value, thereby converting
the value to text. I am looking for an easier way to
accomplish this feat. In particular, I wish to convert a
stgring of date cells to text cells.

Any ideas out there?

Mark

 

[Frank Kabel]

Hi
you may use the formula
=TEXT(A1,"MM-DD-YYYY")
in an adjacent column

 

[Norman Harker]

Hi Mark!

You'll need a helper column:

=TEXT(A1,"dd-mmm-yyyy")
Once you have as text you can then use:

Copy > Edit > Paste Special > Values > OK

Then you can delete or paste over the originals.

But why do you want to do this? Just in case there's a problem with
what's behind the question.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Mark]

Worked - thank you.

Mark