Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
Date Format will not change
Done but it still hasnt changed :(- lilly83
- Post #6
- Forum: Microsoft: Office
-
Date Format will not change
I changed the format of the colum to a DATE number format and copied it. Then I copied it and pasted in a new colum from row 1 but it didnt work. It is still in the same format Purchase Date 41334 41365 41487 41518 41548 1/14/13 41579 41487 The prob is there are 100's of ones like this I need...- lilly83
- Post #4
- Forum: Microsoft: Office
-
Date Format will not change
I am using excel 2013 and I have donwloaded an excel file which has a date column but some of the dates wont change format to date format. See example below Purchase Date 01-03-13 01-04-13 01-08-13 01-09-13 01-10-13 1/14/13 01-11-13 The second last one from the bottom 1/14/13 will not chnage...- lilly83
- Thread
- Replies: 12
- Forum: Microsoft: Office
