numbers in XX:X format

[Microsoft]

I have entries that are pasted from HTML they appear as XX:XX ie; 31:24. NOT
TIMES! I can not alter the data before it gets to excell ,and excell wants
to make them times of day that are incomprehensible!

I format the cell for text , then even after repasting, it still sees it as
a
time of day. WHY IS THERE NO FIX FOR THIS LIMITATION!!!!!!!!

SOMETIMES if I paste as Unicode it works, but not consistently


PLEASE I MUST HAVE THIS WORKING . MY last post appears to have disappeared
off this board!

I am eplacnf the : with a . ad using a roundup function, but the data comes
with a : seperator

Thanks in advance.,

Mark

 

[Tim Otero]

Harlan Grove answered your previous post of 7/24 with a solution to which
you did not respond. See here:

http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&selm=vsYTa.12930%2
4cJ5.1103%40www.newsranger.com

Was this not working? If not you should have posted back...

tim