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 10 Registration date Thursday July 27, 2017 Status Member Last seen August 29, 2017 - Aug 29, 2017 at 10:00 AM
eunice3301 Posts 10 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
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
Related:
- Date format
- Excel date format dd.mm.yyyy - Guide
- Format factory - Download - Other
- Kingston format utility - Download - Storage
- Swissknife format - Download - Storage
- Marksheet format in excel - Guide
1 response
eunice3301
Posts
10
Registration date
Thursday July 27, 2017
Status
Member
Last seen
August 29, 2017
Aug 29, 2017 at 10:00 AM
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 =)