WHY DOES DATE FORMAT CHANGE IN COLUMN
 

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?

WHY DOES DATE FORMAT CHANGE IN COLUMN
 

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

"Kerry Johnson" wrote:

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?