Date format

Closed
ayeshaali11 Posts 1 Registration date Wednesday July 5, 2017 Status Member Last seen July 5, 2017 - Updated on Jul 6, 2017 at 04:42 PM
eunice3301 Posts 13 Registration date Thursday July 27, 2017 Status Member Last seen August 29, 2017 - Aug 29, 2017 at 10:00 AM
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

eunice3301 Posts 13 Registration date Thursday July 27, 2017 Status Member Last seen August 29, 2017
Aug 29, 2017 at 10:00 AM
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 =)
0