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

Add leading 0 to csv import text/time H:MM
 

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

Add leading 0 to csv import text/time H:MM
 

If the file retains its csv extension, by default excel will treat the data
as time, not as text. If the file has been renamed to txt, the text import
wizard allows you to specify the format of each column on import.

In either case, if it is treated as time but not formatted as you want it,
Format/ Cells/ will allow you to specify hh:mm
--
David Biddulph

"Mic" wrote in message
...
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

Add leading 0 to csv import text/time H:MM
 

Unfortunatly, HH:MM will not work since a 24 hour clock would not work in
this instance:
I would like to add the leading 0, but not to have 08:30 pm not equal= to
20:30.

"David Biddulph" wrote:

If the file retains its csv extension, by default excel will treat the data
as time, not as text. If the file has been renamed to txt, the text import
wizard allows you to specify the format of each column on import.

In either case, if it is treated as time but not formatted as you want it,
Format/ Cells/ will allow you to specify hh:mm
--
David Biddulph

"Mic" wrote in message
...
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

Add leading 0 to csv import text/time H:MM
 

hh:mm AM/PM
--
David Biddulph

"Mic" wrote in message
...
Unfortunatly, HH:MM will not work since a 24 hour clock would not work in
this instance:
I would like to add the leading 0, but not to have 08:30 pm not equal= to
20:30.

"David Biddulph" wrote:

If the file retains its csv extension, by default excel will treat the
data
as time, not as text. If the file has been renamed to txt, the text
import
wizard allows you to specify the format of each column on import.

In either case, if it is treated as time but not formatted as you want
it,
Format/ Cells/ will allow you to specify hh:mm
--
David Biddulph

"Mic" wrote in message
...
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

Add leading 0 to csv import text/time H:MM
 

OMG so simple, Thanks

"David Biddulph" wrote:

hh:mm AM/PM
--
David Biddulph

"Mic" wrote in message
...
Unfortunatly, HH:MM will not work since a 24 hour clock would not work in
this instance:
I would like to add the leading 0, but not to have 08:30 pm not equal= to
20:30.

"David Biddulph" wrote:

If the file retains its csv extension, by default excel will treat the
data
as time, not as text. If the file has been renamed to txt, the text
import
wizard allows you to specify the format of each column on import.

In either case, if it is treated as time but not formatted as you want
it,
Format/ Cells/ will allow you to specify hh:mm
--
David Biddulph

"Mic" wrote in message
...
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

Add leading 0 to csv import text/time H:MM
 

Now is there a way to get rid of the AM and PM that is displayed?

"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