Need a Macro to change hhhh:mm:ss (BT format) to hh:mm:ss

[Guest]

British Telecom use hhhh:mm:ss as time format in downloaded bills, which
Excel 97 does not recognise. It can be converted to Excel by deleting two
leading "h"s. I've tried to make a macro but, if (eg) I convert 10 times and
then run the macro for the next ten, I just get the first ten repeated.

 

[Douglas J. Steele]

I'd suggest asking this in a newsgroup related to Excel.

This newsgroup is for questions about using macros in Access, the database
product that's part of Office Professional.