Is it possible to create a macro to apply a formula to selected cells? I
am importing data from AVAYA which displays elapsed time in seconds.
When copying into excel, the number displays but is not formatted as a
number. I want to create a macro that will recognize the number and
then apply a formula to convert it to hours and minutes. Any ideas?


--
Gina921
------------------------------------------------------------------------
Gina921's Profile: http://www.excelforum.com/member.php...o&userid=24759
View this thread: http://www.excelforum.com/showthread...hreadid=383301