Excel

[Closed]
Report
Posts
2
Registration date
Thursday October 2, 2014
Status
Member
Last seen
October 9, 2014
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

I have report which consist date 1-30 in that first 15 days different format. last 15 days different format. first 15 days i can change date format but i m unable to do last 15 date format not changing.
I want to do privet table using this information but due to date format different in privet table date not appear n order . so kindly advised me.
13/09/2014 16:22:53
13/09/2014 16:12:30
13/09/2014 11:40:40
13/09/2014 10:22:39
12/9/2014 21:21
12/9/2014 21:18
12/9/2014 19:13
12/9/2014 19:11
12/9/2014 19:01
12/9/2014 18:49
12/9/2014 18:45
12/9/2014 17:43
12/9/2014 17:18
12/9/2014 16:38

3 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
how should date to be entered in YOUR excel either as m/d/yy or d/m/yy

see control panel -region and language=short date
Posts
2
Registration date
Thursday October 2, 2014
Status
Member
Last seen
October 9, 2014

first 15 m/d/yy
second 15 d/m/yy
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
I wonder how can you do that. see controlpanel-regiona and language-short date

according to that you enter dates. you can format anyway you like. that is only for viewing purposes only.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!