Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() British Telecom use hhhh:mm:ss time format in downloaded bills, which Excel97 does not recognise. Cannot re-format to hh:mm:ss - Excel does not recognise hhhh:mm:ss as a numeric format ??. Tried (with no experience) to create a macro but having set it up to remove first two h's from first ten entries (of 546) when I applied the macro to entry eleven, it simply replicated the values of the first ten. Can anybody tell me what to do or where I can find out more about macros than is in Excel97's "Help" section ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
Windows ME and Windows XP Function of key F2 is different | Excel Worksheet Functions |