Macro for Br.Telecom a/c

B

BT Bill

BT use hhhh:mm:ss as time format in downloaded bills, which Excel does not
recognise. It can be changed to recognisable format by deleting two h's. When
I made a macro to do this using the first 10 entries, and then applied the
macro to the second 10, it just replicated the figures in the first 10.
 
B

Bob Phillips

Change the time format to [hh]:mm:ss

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Training on macros in Excel97 using Windows 98 1
Convert hhhh:mm:ss to hh:mm:ss (macro ?) 1
Improving Macro That Keeps First Letter 0
How to modify and updte specific styles for specific paragraphs across the document 0
Time formatting - Excel 2003 1
VBA word change keys 0
Need a Macro to change hhhh:mm:ss (BT format) to hh:mm:ss 1
WORD VBA Search and switch to advanced ... 1

Top