View Single Post
  #5   Report Post  
Myrna Larson
 
Posts: n/a
Default

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.