View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ozgrid.com ozgrid.com is offline
external usenet poster
 
Posts: 464
Default alter column ref

Go into Excel Options and uncheck R1C1 Reference Style.



--
Regards
Dave Hawley
www.ozgrid.com
"Kaz" wrote in message
...
my column references are displayed in numeric rather than alphabetic. eg.
the
first column is 1, instead of A. Can anyway help me? thanks Kaz