Date Formatting

[Dave]

Is there a way to enter dates before 1900 and format them
so they look like and sort with dates after 1900?

 

[Jim]

I do not think that is a native capability of XL. You could try a Google
search; I think either www.cpearson.com or www.j-walk.com have something
along those lines.