View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default How do I rename columns from letters to numbers

Tools--Options--General and check R1C1 reference style.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"peter3318" wrote:

How do I change column headings from letters (A, B, C, D........) to numbers
(1, 2, 3, 4, ............)?