View Single Post
  #3   Report Post  
Old February 20th 10, 07:24 PM posted to microsoft.public.excel.setup
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
First recorded activity by ExcelBanter: Sep 2009
Posts: 833
Default How do I change column from numeric to alphabet?

In EXCEL 2007:-

Office Button (top left hand corner)

Excel Options (lower right hand corner)


- make sure that there is no tick in the box called:-

R1C1 reference style

If my comments have helped please hit Yes.


"Dave Peterson" wrote:

In xl2003 menus:

Tools|Options|General Tab|uncheck R1C1 Reference style.

wgfpshaky wrote:

I have numbers in both columns and rows. I would like to have letters
accrosss the top.


Dave Peterson