Add leading 0 to csv import text/time H:MM
Hi,
I did alot of searching but did not find this one exactly:
I am importing a csv file into excel as text.
The column in question is a time value formated like this, 8:30
The value needs to look like this, 08:30 for a whole column.
Any way to do this?
Thanks
Mic
|