RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello Good Evening, This is the kind of data I receive from a client. The dates are written in different formats. I tried converting the text in the adjoining column by using the formula =text(A1,"dd-mm-yyyy") but I was not able to convert the whole range. Please suggest any other formula if any, that I can apply .?
Book2 | ||||
---|---|---|---|---|
A | B | |||
1 | 10-04-2019 | 10-04-2019 | ||
2 | 10-04-2019 | 10-04-2019 | ||
3 | 30-04-2019 | 30-04-2019 | ||
4 | 21.05.2019 | 21.05.2019 | ||
5 | 21.05.2019 | 21.05.2019 | ||
6 | 30.05.2019 | 30.05.2019 | ||
7 | 17.05.2019 | 17.05.2019 | ||
8 | 23.05.2019 | 23.05.2019 | ||
9 | 23.05.2019 | 23.05.2019 | ||
10 | 22.05.2019 | 22.05.2019 | ||
11 | 31.05.2019 | 31.05.2019 | ||
12 | 09.05.2019 | 09.05.2019 | ||
13 | 08.05.2019 | 08.05.2019 | ||
14 | 02.05.2019 | 02.05.2019 | ||
15 | 06.05.2019 | 06.05.2019 | ||
16 | 27.05.2019 | 27.05.2019 | ||
17 | 23.05.2019 | 23.05.2019 | ||
18 | 22.05.2019 | 22.05.2019 | ||
19 | 24.05.2019 | 24.05.2019 | ||
20 | 25.05.2019 | 25.05.2019 | ||
21 | 07.05.2019 | 07.05.2019 | ||
22 | 29.05.2019 | 29.05.2019 | ||
23 | 31.05.2019 | 31.05.2019 | ||
24 | 22.05.2019 | 22.05.2019 | ||
25 | 01.06.2019 | 01.06.2019 | ||
26 | 08.06.2019 | 08.06.2019 | ||
27 | 06.06.2019 | 06.06.2019 | ||
28 | 10.06.2019 | 10.06.2019 | ||
29 | 12.06.2019 | 12.06.2019 | ||
30 | 08.06.2019 | 08.06.2019 | ||
31 | 14.06.2019 | 14.06.2019 | ||
32 | 19.06.2019 | 19.06.2019 | ||
33 | 17.06.2019 | 17.06.2019 | ||
34 | 24.06.2019 | 24.06.2019 | ||
35 | 20.06.2019 | 20.06.2019 | ||
36 | 25.06.2019 | 25.06.2019 | ||
37 | 22.06.2019 | 22.06.2019 | ||
38 | 26.06.2019 | 26.06.2019 | ||
39 | 21.06.2019 | 21.06.2019 | ||
40 | 26.07.2019 | 26.07.2019 | ||
41 | 05.07.2019 | 05.07.2019 | ||
42 | 05.07.2019 | 05.07.2019 | ||
43 | 08.07.2019 | 08.07.2019 | ||
44 | 08.07.2019 | 08.07.2019 | ||
45 | 06.07.2019 | 06.07.2019 | ||
46 | 12.07.2019 | 12.07.2019 | ||
47 | 08.07.2019 | 08.07.2019 | ||
48 | 09.07.2019 | 09.07.2019 | ||
49 | 10.07.2019 | 10.07.2019 | ||
50 | 18.07.2019 | 18.07.2019 | ||
51 | 18.07.2019 | 18.07.2019 | ||
52 | 18.07.2019 | 18.07.2019 | ||
53 | 24.07.2019 | 24.07.2019 | ||
54 | 30.07.2019 | 30.07.2019 | ||
55 | 24.07.2019 | 24.07.2019 | ||
56 | 26.07.2019 | 26.07.2019 | ||
57 | 27.07.2019 | 27.07.2019 | ||
58 | 31.07.2019 | 31.07.2019 | ||
59 | 31.07.2019 | 31.07.2019 | ||
60 | 01-08-2019 | 01-08-2019 | ||
61 | 07-08-2019 | 07-08-2019 | ||
62 | 6.8.2019 | 6.8.2019 | ||
63 | 02-08-2019 | 02-08-2019 | ||
64 | 12-08-2019 | 12-08-2019 | ||
65 | 14-08-2019 | 14-08-2019 | ||
66 | 16-08-2019 | 16-08-2019 | ||
67 | 19-08-2019 | 19-08-2019 | ||
68 | 26-08-2019 | 26-08-2019 | ||
69 | 30.8.2019 | 30.8.2019 | ||
70 | 29-08-2019 | 29-08-2019 | ||
71 | 29-08-2019 | 29-08-2019 | ||
72 | 29-08-2019 | 29-08-2019 | ||
73 | 19.8.2019 | 19.8.2019 | ||
74 | 6.8.2019 | 6.8.2019 | ||
75 | 31.8.2019 | 31.8.2019 | ||
76 | 31.8.2019 | 31.8.2019 | ||
77 | 16.8.2019 | 16.8.2019 | ||
78 | 6.8.2019 | 6.8.2019 | ||
79 | 19.8.2019 | 19.8.2019 | ||
80 | 31.8.2019 | 31.8.2019 | ||
81 | 10.09.2019 | 10.09.2019 | ||
82 | 10.09.2019 | 10.09.2019 | ||
83 | 10.09.2019 | 10.09.2019 | ||
84 | 11.09.2019 | 11.09.2019 | ||
85 | 26.09.2019 | 26.09.2019 | ||
86 | 03.09.2019 | 03.09.2019 | ||
87 | 10.09.2019 | 10.09.2019 | ||
88 | 11.09.2019 | 11.09.2019 | ||
89 | 23.09.2019 | 23.09.2019 | ||
90 | 26.09.2019 | 26.09.2019 | ||
91 | 28.09.2019 | 28.09.2019 | ||
92 | 30.09.2019 | 30.09.2019 | ||
93 | 12.09.2019 | 12.09.2019 | ||
94 | 09.09.2019 | 09.09.2019 | ||
95 | 05.09.2019 | 05.09.2019 | ||
96 | 23.09.2019 | 23.09.2019 | ||
97 | 07.09.2019 | 07.09.2019 | ||
98 | 18.09.2019 | 18.09.2019 | ||
99 | 16.09.2019 | 16.09.2019 | ||
100 | 21.09.2019 | 21.09.2019 | ||
101 | 10.09.2019 | 10.09.2019 | ||
102 | 10.09.2019 | 10.09.2019 | ||
103 | 16.09.2019 | 16.09.2019 | ||
104 | 06.09.2019 | 06.09.2019 | ||
105 | 21-10-2019 | 21-10-2019 | ||
106 | 10-10-2019 | 10-10-2019 | ||
107 | 16-10-2019 | 16-10-2019 | ||
108 | 31-10-2019 | 31-10-2019 | ||
109 | 30-10-2019 | 30-10-2019 | ||
110 | 14-10-2019 | 14-10-2019 | ||
111 | 16-10-2019 | 16-10-2019 | ||
112 | 16-10-2019 | 16-10-2019 | ||
113 | 17-10-2019 | 17-10-2019 | ||
114 | 01-10-2019 | 01-10-2019 | ||
115 | 26-10-2019 | 26-10-2019 | ||
116 | 31-10-2019 | 31-10-2019 | ||
117 | 08-10-2019 | 08-10-2019 | ||
118 | 02-10-2019 | 02-10-2019 | ||
119 | 17-10-2019 | 17-10-2019 | ||
120 | 09-10-2019 | 09-10-2019 | ||
121 | 10-10-2019 | 10-10-2019 | ||
122 | 09-10-2019 | 09-10-2019 | ||
123 | 24-10-2019 | 24-10-2019 | ||
124 | 11-10-2019 | 11-10-2019 | ||
125 | 21-10-2019 | 21-10-2019 | ||
126 | 18-10-2019 | 18-10-2019 | ||
127 | 31-10-2019 | 31-10-2019 | ||
128 | 16-10-2019 | 16-10-2019 | ||
129 | 02-11-2019 | 02-11-2019 | ||
130 | 06-11-2019 | 06-11-2019 | ||
131 | 14-11-2019 | 14-11-2019 | ||
132 | 30/11/2019 | 30/11/2019 | ||
133 | 19-11-2019 | 19-11-2019 | ||
134 | 19-11-2019 | 19-11-2019 | ||
135 | 19-11-2019 | 19-11-2019 | ||
136 | 19-11-2019 | 19-11-2019 | ||
137 | 19/11.2019 | 19/11.2019 | ||
138 | 02-11-2019 | 02-11-2019 | ||
139 | 19-11-2019 | 19-11-2019 | ||
140 | 20-11-2019 | 20-11-2019 | ||
141 | 30-11-2019 | 30-11-2019 | ||
142 | 01-11-2019 | 01-11-2019 | ||
143 | 06-11-2019 | 06-11-2019 | ||
144 | 11-11-2019 | 11-11-2019 | ||
145 | 16-11-2019 | 16-11-2019 | ||
146 | 01.11.2019 | 01.11.2019 | ||
147 | 22.11.2019 | 22.11.2019 | ||
148 | 22.11.2019 | 22.11.2019 | ||
149 | 17.11.2019 | 17.11.2019 | ||
150 | 30.11.2019 | 30.11.2019 | ||
151 | 17.11.2019 | 17.11.2019 | ||
152 | 21.11.2019 | 21.11.2019 | ||
153 | 23.11.2019 | 23.11.2019 | ||
154 | 21.11.2019 | 21.11.2019 | ||
155 | 18.11.2019 | 18.11.2019 | ||
156 | 01.11.2019 | 01.11.2019 | ||
157 | 18-12-2019 | 18-12-2019 | ||
158 | 28-12-2019 | 28-12-2019 | ||
159 | 28-12-2019 | 28-12-2019 | ||
160 | 31-12-2019 | 31-12-2019 | ||
161 | 03-12-2019 | 03-12-2019 | ||
162 | 09-12-2019 | 09-12-2019 | ||
163 | 12-12-2019 | 12-12-2019 | ||
164 | 23-12-2019 | 23-12-2019 | ||
165 | 14-12-2019 | 14-12-2019 | ||
166 | 16-12-2019 | 16-12-2019 | ||
167 | 26-12-2019 | 26-12-2019 | ||
168 | 26-12-2019 | 26-12-2019 | ||
169 | 28-12-2019 | 28-12-2019 | ||
170 | 02-12-2019 | 02-12-2019 | ||
171 | 24-12-2019 | 24-12-2019 | ||
172 | 27-12-2019 | 27-12-2019 | ||
173 | 13-12-2019 | 13-12-2019 | ||
174 | 15-12-2019 | 15-12-2019 | ||
175 | 15-12-2019 | 15-12-2019 | ||
176 | 31-12-2019 | 31-12-2019 | ||
177 | 18-12-2019 | 18-12-2019 | ||
178 | 26.12.2019 | 26.12.2019 | ||
179 | 19.12.2019 | 19.12.2019 | ||
180 | 31.12.2019 | 31.12.2019 | ||
181 | 17.12.2019 | 17.12.2019 | ||
182 | 15.12.2019 | 15.12.2019 | ||
183 | 01.12.2019 | 01.12.2019 | ||
184 | 02.12.2019 | 02.12.2019 | ||
185 | 03.12.2019 | 03.12.2019 | ||
186 | 08-01-2020 | 08-01-2020 | ||
187 | 21-01-2020 | 21-01-2020 | ||
188 | 21-01-2020 | 21-01-2020 | ||
189 | 31-01-2020 | 31-01-2020 | ||
190 | 30-01-2020 | 30-01-2020 | ||
191 | 16-01-2020 | 16-01-2020 | ||
192 | 07-01-2020 | 07-01-2020 | ||
193 | 10-01-2020 | 10-01-2020 | ||
194 | 28-01-2020 | 28-01-2020 | ||
195 | 25-01-2020 | 25-01-2020 | ||
196 | 20-01-2020 | 20-01-2020 | ||
197 | 20-01-2020 | 20-01-2020 | ||
198 | 13-01-2020 | 13-01-2020 | ||
199 | 21-01-2020 | 21-01-2020 | ||
200 | 31-01-2020 | 31-01-2020 | ||
201 | 22-01-2020 | 22-01-2020 | ||
202 | 27-01-2020 | 27-01-2020 | ||
203 | 27.01.20 | 27.01.20 | ||
204 | 28.01.20 | 28.01.20 | ||
205 | 18.01.20 | 18.01.20 | ||
206 | 19.01.20 | 19.01.20 | ||
207 | 15.01.20 | 15.01.20 | ||
208 | 31.01.2020 | 31.01.2020 | ||
209 | 30.01.20 | 30.01.20 | ||
210 | 28.01.20 | 28.01.20 | ||
211 | 18.01.20 | 18.01.20 | ||
212 | 17-02-2020 | 17-02-2020 | ||
213 | 21-02-2020 | 21-02-2020 | ||
214 | 29-02-2020 | 29-02-2020 | ||
215 | 24-02-2020 | 24-02-2020 | ||
216 | 24-02-2020 | 24-02-2020 | ||
217 | 24-02-2020 | 24-02-2020 | ||
218 | 24.2.2020 | 24.2.2020 | ||
219 | 03-02-2020 | 03-02-2020 | ||
220 | 03-02-2020 | 03-02-2020 | ||
221 | 11-02-2020 | 11-02-2020 | ||
222 | 17-02-2020 | 17-02-2020 | ||
223 | 24-02-2020 | 24-02-2020 | ||
224 | 29.02.2020 | 29.02.2020 | ||
225 | 01-02-2020 | 01-02-2020 | ||
226 | 07-02-2020 | 07-02-2020 | ||
227 | 11-02-2020 | 11-02-2020 | ||
228 | 20-02-2020 | 20-02-2020 | ||
229 | 29-02-2020 | 29-02-2020 | ||
230 | 28.2.2020 | 28.2.2020 | ||
231 | 25.2.20 | 25.2.20 | ||
232 | 15-02-2020 | 15-02-2020 | ||
233 | 12-02-2020 | 12-02-2020 | ||
234 | 25-02-2020 | 25-02-2020 | ||
235 | 17.02.2020 | 17.02.2020 | ||
236 | 11.02.2020 | 11.02.2020 | ||
237 | 15.02.2020 | 15.02.2020 | ||
238 | 10.02.2020 | 10.02.2020 | ||
239 | 13.2.2020 | 13.2.2020 | ||
240 | 15.2.2020 | 15.2.2020 | ||
241 | 14.2.20 | 14.2.20 | ||
242 | 5.2.2020 | 5.2.2020 | ||
243 | 8.2.2020 | 8.2.2020 | ||
244 | 8.3.2020 | 8.3.2020 | ||
245 | 11.3.2020 | 11.3.2020 | ||
246 | 31.3.2020 | 31.3.2020 | ||
247 | 31.3.2020 | 31.3.2020 | ||
248 | 16.3.2020 | 16.3.2020 | ||
249 | 17.3.2020 | 17.3.2020 | ||
250 | 6.3.2020 | 6.3.2020 | ||
251 | 03-03-2020 | 03-03-2020 | ||
252 | 11.3.2020 | 11.3.2020 | ||
253 | 11.3.2020 | 11.3.2020 | ||
254 | 14.3.2020 | 14.3.2020 | ||
255 | 16.3.2020 | 16.3.2020 | ||
256 | 11.3.2020 | 11.3.2020 | ||
257 | 31.3.2020 | 31.3.2020 | ||
258 | 3.3.2020 | 3.3.2020 | ||
259 | 29.3.2020 | 29.3.2020 | ||
260 | 19.3.2020 | 19.3.2020 | ||
261 | 5.3.2020 | 5.3.2020 | ||
262 | 20.3.2020 | 20.3.2020 | ||
263 | 6.3.2020 | 6.3.2020 | ||
264 | 7.3.2020 | 7.3.2020 | ||
265 | 6.3.2020 | 6.3.2020 | ||
266 | 7.3.2020 | 7.3.2020 | ||
267 | 16.3.2020 | 16.3.2020 | ||
268 | 18.3.2020 | 18.3.2020 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1:B268 | B1 | =TEXT(A1,"dd-mm-yyyy") |