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.