And for XL2007, click Office Button, Excel Options Button, select Formulas
from the left hand listing and uncheck "R1C1 reference style" in the
"Working with formulas" section in the right hand listing.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
In XL2003 and earlier... Tools/Options from the menu bar, click General
tab, uncheck the first item ("R1C1 reference style").

--
Rick (MVP - Excel)



"lovnlife" wrote in message
...
I am not sure how to get the worksheet to show alpha in the columns and
formulas instead of numeric.