Hello all,

I'm sorry if this is a little off topic for this newsgroup. I tried looking
for a more reasonable NG, but didn't see anything that jumped out at me.

Using Excel 2002 SP3

I opened a .WK4 file in Excel (I'm guessing that is a Lotus 1-2-3 file). I
then tried to use the DATE(y,m,d) function. It worked okay as long as month
was 1-12 and day was 1-28, 1-30, or 1-31 (depending on the month).

But the "extended functionality" of DATE would not work like it does in a
new Excel workbook. Every time month or day was changed to a number outside
of those ranges, it would return #NUM!. I tried saving it as a Microsoft
Excel Workbook (1st choice), but it still behaves the same way.

Is there any way to open/save this file so the extended functionality of
DATE will work?

Thanks for any help anyone can provide,

Conan Kelly