If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Editing time that has its colon removed
I have a large CSV file that has the time column stripped of its colon
meant to distinguish hours and minutes. ie. 9:20 is displayed 9200. 23:55 is displayed as 2355 Is there a way of adding a colon automatically in the right spot? I have over 875000 of these to do. |
#2
|
|||
|
|||
Editing time that has its colon removed
Question... given how 9:20 is changed to 9200, what would 1:20 and 12:00
(and, depending on how you show it, maybe 0:12 as well) be changed to? -- Rick (MVP - Excel) "rhhince" wrote in message ... I have a large CSV file that has the time column stripped of its colon meant to distinguish hours and minutes. ie. 9:20 is displayed 9200. 23:55 is displayed as 2355 Is there a way of adding a colon automatically in the right spot? I have over 875000 of these to do. |
Thread Tools | |
Display Modes | |
|
|