Forgot to add,
Excel 2000
system creating csv file does not have the leading zero


"Mic" wrote:

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