Changing a date to text string

[djbwantstoknow]

In converting to a different program I need to change the dates into a piece of text for the upload file.
Existing program requires the dates to be in a standard date format: 2014-12-15. The new program requires the dates to be a text string 12152014 (not a date, just a text string) How can I convert the column of dates into a text string. Anything I ve tried to change the date to a piece of text just changes the date to it s underlying serial number.

 

[JoeMo]

Sheet1

*	A	B	C
1	2014-12-15	12152014	2

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:75px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula B1 =TEXT(A1,"mmddyyyy") C1 =TYPE(B1) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[Rick Rothstein]

In converting to a different program I need to change the dates into a piece of text for the upload file.
Existing program requires the dates to be in a standard date format: 2014-12-15. The new program requires the dates to be a text string 12152014 (not a date, just a text string) How can I convert the column of dates into a text string. Anything I ve tried to change the date to a piece of text just changes the date to it s underlying serial number.

Assuming your dates start in cell A2, put this formula...

=TEXT(A2,"mmddyyyy")

in Row 2 of an unused column and copy it down to the end of the data in Column A (where I have assumed your dates to be located at), then select all those cells where you just put the formula and copy them, then (assuming you want to overwrite your real dates with their text equivalents) select cell A2 and then use "Paste Special/Values" to perform the overwrite.