Click Tools Options General tab
Uncheck R1C1 reference style OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Mr. Good" <Mr. wrote in message
...
My spreadsheet has rows & columns in numeric format where I want it to be
alphnumeric for columns & numeric for rows.

This is messing up my calculations... I'm sure it's something simple but
can't figure it out.

Thanks.

Jon