You've probably acidentally switched to R1C1 reference style. You can swtich back by (XL 2000/2003):
Tools --> Options --> General --> [de-select] R1C1 reference style
Can't remember where it is in XL 2007/10 but almost certainly it'll be somewhere in Office Button --> Excel Options.
Regards
Adam