WHY DOES DATE FORMAT CHANGE IN COLUMN

[Kerry Johnson]

SET DATE FORMAT DD/MM/YY FINE UNTIL ROW 24 THEN FORMAT CHANGES TO MM/DD/YY &
NOTHING WILL RECTIFY, HAVE RESET COUNTRY, STYLE ,SETUP, PREFERENCES. WHAT
ELSE TO DO?

 

[Andrea Jones]

Try formatting the cell as DD/MM/YY again then click on the cell, press F2
followed by Enter. If that doesn't fix it, make sure there isn't an
apostrophe before the date (check in the formula bar) forcing it to be text.

Andrea Jones
www.stratatraining.co.uk
www.wrekinpublishing.com