| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change satellite julian date format YYYYDDDHHMMSS to excel date ti | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| Change general format to US date format | Excel Discussion (Misc queries) | |||
| how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
Hybrid Mode
