Excel Edit cell in Excel

Joined
Feb 20, 2011
Messages
2
Reaction score
0
I have a column of numbers that represent time. However there is no ":" seperator. I need a macro that can place the colon appropriately. Example:

712 changes to 7:12
804 changes to 8:04
1456 changes to 14:56
 
Back
Top