View Single Post
  #1   Report Post  
BT Bill
 
Posts: n/a
Default Training on macros in Excel97 using Windows 98


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 ?