Previous Topic Next Topic

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
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

Related:

1 response

Answer 1 / 1
eunice3301 Posts 10 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

Similar discussions

Unsupported signal. Please check device output
S.Agnew -
Yaya68 -

14 responses
How can I publish a study that I have done on this website?
simonrasho -
Daniel_CCM -

1 response
Pc Game show unsupported signal check your output device
Shravanshinde2424 -
dwebb -

1 response
How do i change date format in (dd.mm.yyyy)
Talha -
Catherine -

6 responses