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.