Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro for Br.Telecom a/c
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. -- British Telecom |
#2
|
|||
|
|||
Change the time format to [hh]:mm:ss
-- HTH RP (remove nothere from the email address if mailing direct) "BT Bill" wrote in message ... 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. -- British Telecom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
automatic macro update | Excel Worksheet Functions | |||
Date macro | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro Formula revision? | Excel Worksheet Functions |