Date-Time cose to text value

[solo7]

I have a list of several hundred names and associated dates in an Excel Spreadsheet. The date is in the format of YYYY-MM-DD. I need to get this data into a .csv file, which should be straight forward enough. However when I save as a .csv the date is in the Date-Time code (ie, 32844 = 1989-12-02).

How can I export these dates as dates and not in the Date-Time number ?

solo7

 

[xlbo]

CSV = Comma Seperated VALUES

Dates are just FORMATS

a VALUE file does not use formats

You must either:
a) convert dates to TEXT in that format or
b) use a different type of text file

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[solo7]

Cheers Geoff

I have managed to get something like what I want using the 'TEXT to Columns' under the Data tab. This takes the date format out and stores the data in a General format.


Solo7

 

[SkipVought]

Solo,

What Geoff was pointing out is that a Date is a NUMBER.

This takes the date format out and stores the data in a General format.

You did NOTHING to the underlying NUMBER. You could have seen the same results by formatting the source date column as General.

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}