working with XX:XX entries

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 incomprehible!

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


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


Thanks in advance.,

Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

working with entries in XX:XX format 2
Space at end of multi page list to accommodate new entries 1
numbers in XX:X format 1
Blocking junk email 0
Function in Excel to count and list number of entries of text valuesin a row. 2
problem working with time data imported from text file 1
How To Rapidly Copy Formulas? 0
Receiving unexpected Duration 0

Top