Well, you learn something new every day. From
http://www.clarionmag.com/cmag/v4/v4n12exceldates.html
"If you have a CSV file or other data that contains an unformatted Clarion
date, and you wish to view the date in Excel, you'll need to convert the
Clarion standard date to an Excel date.
Fortunately, that's easy to do. Just create a formula in another column,
subtracting 36161 from the value and formatting it as a date. Clarion
standard dates and the Excel DATE() function both have an arbitrary "Day
1" - for Excel, this is 1/1/1900, while Clarion's Day 1 is 12/28/1800
(although the first usable date is Day 4, or 1/1/1801). The number 36161 is
the difference in days between these two dates."
HTH,
Bernie
MS Excel MVP
