Excel is programmed to auto interpret numbers that look like date values as
Dates.
True, but 1-4531 and 2-4531 don't "look like" dates to me. How would you
describe the format?
In Excel office 2k if you type 1-4351 in any cell the returned value is
Jan-51, 2-4531 =Feb-51 etc.
|