Date format pre-1900.

C

Craig & Co.

Hi,

I have a table of immigration ships that have arrived in Australian shores.

Some....okay most.....of the ships arrived before 1900.

I was trying to sort by the arrival date, which is in the format of
DD MMM YYYY, but that didn't work, as there were some 1900 dates.

Tried to re-style the column to DD/MM/YYYY, but the pre-1900 dates
don't change to the new style.

Any suggestions on how to utilise the pre-1900 dates, so that Excel can
recognise
them.

Cheers in advance.
Craig.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

REPOST: Date format pre-1900. 2
Recognising dates pre-1900 14
date formt in Excel 1
Formatting dates prior to 1900 7
Is there a way to format yyyy/mm/dd before 1900 2
Date Format 2
Date Format - Conversion 1
Sorting dates before 1900 3

Top