Sorry - my writing and mind don't seem to be going together today. Let me
start the second question again -- Now that I have this particular
spreadsheet sorted and also still in the mm/dd/yyyy format -- how do I put
other spreadsheets that are in the 3-column (mo, day, year) format into one
column in the mm/dd/yyyy format? Is there a way to merge these three so it
knows it is a date and shows the date format of mm/dd/yyyy? Hopefully I am
making more sense now -- I realized since the original one I did your value
formula on never changed the original column entries that when I wrote the
question it sort-of-sounded like it HAD changed and wanted you to know that
wasn't the case -- just needing the second answer for another spreadsheet
that is in the 3-column date format and need it combined into the single
column format so it is consistent when it is merged in a webpage I use.
Thanks.

"sandage_2000" wrote:

BTW - this DID work and it was also answer to another problem I had been
having because sometimes I have to merge different spread sheets and some
were typed in 3 columns (mo, day, year) and others in one column in
mm/dd/yyyy format -- so now I can use your answer here for converting that
too for the sorts. Double thanks and hopefully you or someone can tell me
how to get back to the single column date format.

Judy M.