Special formatting in CSV file

[jpf777777]

I have a CSV file that passes a time stamp that I would like to have reformatted as it is loaded. It seems to me that within the CSV field formatting commands can be passed.

Does anyone have any ideas?

The data looks like: 8/9/2009 8:32:02 am.
Excel reformatted it: 8/9/2009 8:32 dropping the seconds and the am/pm.
We have figured out how to have it passed as a literal but we need it in a time stamp format.

[Cheeky Charlie]

um... formatting doesn't remove information, think of it as a lens on information, so just redefine the formatting and you don't need to do anything else:
custom format:
d/m/yyyy h:mm:ss am/pm

HTH

[jpf777777]

My ultimate goal is for the CSV file to be created by a mainframe and emailed to the user without ever being loaded into Excel.

Since I have no way of reformatting a cell by using a macro I was really looking for a way to pass the information needed to format a cell when Excel is eventually loaded by appending it to the CSV data.

We do something similar for hyper links but I can't seem to find the correct combination for a time stamp.

[Cheeky Charlie]

I'd be surprised if you could do that... but we learn something new every day, as they say.