Changing formatted dates to true values
Posted by Dawn Rizzo on February 12, 2002 11:37 AM
I have comma delimited text that I am importing into Excel. The file inmcludes a colunm that has month, day, year, hour, minute second (mm/dd/yyyy hh:mm:ss).
We need to drop the seconds and round to the nearest minute. We can get it to do this with custom formatting, but we need to make the new value the TRUE value. We have tried Copy, Paste Special to paste just the value into another column, but it pastes it as the date serial number and keeps the seconds.
Has anyone been successful in converting a date format into the true value?