In xl2003 menus:
Tools|Options|General Tab|
Uncheck the R1C1 Reference style checkbox.
Katie B wrote: Thank you Dave. Prompted me to look at the excel options on my new version and have found the old function now. Many thanks, frustration now solved!