Thanks but,
I should have correctly posed the question as:
I need to enter dates in dd/mm/yyyy format prior to 1900 like 14/02/1834,
and be able to sort them into chronological order. Can this be done?
"Fredrik Wahlgren" wrote:
"Pete the Mag" wrote in message
...
I need to enter dates in dd/mm/yyyy format prior to 1900 like 14/02/1834.
Can this be done?
Thanks
--
Pete
Use an apostrophe as the first character, i.e. '14/02/1834
the postrophe won't appear and Excel will treat what follows as text.
/Fredrik
|