Thread: How do i change column header from R[1] C format to A1 format?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default How do i change column header from R[1] C format to A1 format?
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.

Reply With QuoteReply With Quote