Here is my data:

Cells C2 thru C15 a
MM 15
MM 20
MM 32
MM 62
MM 63
MM 65
MM 74
MM 90
MM 102
MM 102
MM 132
MM 149
MM 161
MM 163

I would like to make them:
1:15
1:20
1:32
1:62
1:63
1:65
1:74
1:90
1:102
1:102
1:132
1:149
1:161
1:163

But instead I get this when I do that EditReplace option:
1:09
1:28
1:37
0.084027778
0.134027778
0.136805556
0.142361111
0.143055556
0.14375
0.156944444
0.175
0.186805556
0.186805556
0.207638889

Thank you.


--
AnimatorElf
------------------------------------------------------------------------
AnimatorElf's Profile: http://www.excelforum.com/member.php...o&userid=32944
View this thread: http://www.excelforum.com/showthread...hreadid=543181