Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I prefill a text field with leading 0s? | Excel Worksheet Functions | |||
Remove text leading zero in text string | Excel Worksheet Functions | |||
Remove text leading zero in text string | Excel Worksheet Functions | |||
Adding Leading Zeros to Text | Excel Discussion (Misc queries) | |||
numbers and text in Excel to read as text keeping the leading zer. | Excel Discussion (Misc queries) |