Posted by Philip on June 19, 2001 10:44 AM
I am opening some .csv files in Excel. One of the fields that it is opening is a field representing a length of time in this format 24:43 (24 minutes and 43 seconds). When the file is opened in Excel it displays totally differently. For instance, a field that has nothing more in it than "19:16" will display as 19:16 but if you click on the cell, it actually says in the edit box, "7:16:00 PM" which makes no sense to me. To make matters worse, occasionally, I will have one of these data records come in as a different format by default. One of them, which in the .csv file is, "42:46" displays as "42:46:00" but if you click on the cell itself, the edit box says that the data in there is really, "1/1/1900 6:46:00 PM" The extra weird part is that if you click in the edit box as if you were going to modify the contents but do not actually make any changes, when you leave the cell, the actual display changes to be, "1/1/00 18:46" Anyone have any good ideas?