Hi,
I need to convert number / text : โ210506โ (21=year 05=month 06=day) to format Date as dd/mm/yyyy
how can i do that ?
Thanks all
Solved! Go to Solution.
This?
CONCATENATE(
RIGHT([Text], 2),
"/",
MID([Text], 3, 2),
"/",
("20" & LEFT([Text], 2))
)
See also:
This?
CONCATENATE(
RIGHT([Text], 2),
"/",
MID([Text], 3, 2),
"/",
("20" & LEFT([Text], 2))
)
See also:
Thanks
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |