Date format [Closed]

Report
Posts
1
Registration date
Wednesday July 5, 2017
Status
Member
Last seen
July 5, 2017
-
Posts
13
Registration date
Thursday July 27, 2017
Status
Member
Last seen
August 29, 2017
-
Hello,

i downloaded one excel sheet containing dates in format December 13th, 2011
. i want to change its date format . i tried changing in format cells , tried the custom but not changing and also not showing in the preview date format

http://static.ccm2.net/ccm.net/pictures/7np4TT1H8g234l28K6PHbnZdQVCq1SX8xB8PPAnvxljoL9ddCwxvjF6q3O5FJDnL-date.png

1 reply

Posts
13
Registration date
Thursday July 27, 2017
Status
Member
Last seen
August 29, 2017

I'm no expert but I don't think it will change. The date setting is only applicable to the date that you entered. I think you have to enter the dates one by one =)