View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norm Shea[_3_] Norm Shea[_3_] is offline
external usenet poster
 
Posts: 3
Default Macro "Time formatting" help

I've got a column of "Time" information that doesn't have a colon separating
the hours from the minutes. I'm looking for a macro to:

move 2 places to the left
insert ":"

An example of the data are
0957
1412
1952

and I want
09:57
14:12
19:52

The data begin at B2.

Thanks,
Norm