Excel

Closed
husni88
Posts
2
Registration date
Thursday October 2, 2014
Status
Member
Last seen
October 9, 2014
- Oct 2, 2014 at 09:16 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Oct 10, 2014 at 12:59 AM
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

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Oct 3, 2014 at 01:35 AM
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
0
husni88
Posts
2
Registration date
Thursday October 2, 2014
Status
Member
Last seen
October 9, 2014

Oct 9, 2014 at 03:53 AM
first 15 m/d/yy
second 15 d/m/yy
0
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Oct 10, 2014 at 12:59 AM
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.
0