numbers in XX:X format

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

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
 
Back
Top