M
Marco
How can I quick convert with a macro my range text?
ex
column A B C D E F
2 row 12.54 45.28 74 33:20 1:52:35 8:45
convert "." with ","
convert ":" with "."
and if number have 2 value 74 add 00
and text time 33:20 add 0
and text time 8:45 add 0:0
result
12,54 45,28 74,00 0.33.20 1.52.35 0.08.45
many thanks
ex
column A B C D E F
2 row 12.54 45.28 74 33:20 1:52:35 8:45
convert "." with ","
convert ":" with "."
and if number have 2 value 74 add 00
and text time 33:20 add 0
and text time 8:45 add 0:0
result
12,54 45,28 74,00 0.33.20 1.52.35 0.08.45
many thanks