I just noticed that in my first post I said it was hours and minutes...it's
actually minutes and seconds...

"Job" wrote in message
...
Ok, I have a small snag. The value in the Cell is 83:15 which is 83 min
and 15 seconds. It's format is actually 83:15:00 as opposed to the others
that are like 15:51. The values that are in this column are just minutes
and seconds. Excel must be converting them as they are put into Excel,
however, I only recieve the file after it has been saved as an .xls.

Any thoughts?



"Job" wrote in message
...
I have a number of cells that have duration of time values, i.e 6:30,5:28;
which are hours and minutes. I actually want these values but in text
format. They would look identical but wouldn't have the Date/Time stamp
on them. What I have done in the past is copy the column of data and
paste into notepad, then made the column a text format then pasted back
from notepad into Excel. This gives the desired result, however, there
has to be a better way of doing this via code or something.

Any help is appreciated.