View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jaime Keen[_2_] Jaime Keen[_2_] is offline
external usenet poster
 
Posts: 2
Default How do columns headings change from letters to numbers?

Thank you very much for your help. :)

"David Biddulph" wrote:

Tools/ Options/ General/ uncheck R1C1 reference style.
--
David Biddulph

"Jaime Keen" <Jaime wrote in message
...
I set up a workbook for Purchase Order tracking with a PO form an
instruction
sheet and a PO vendors listing. My columns were lettered A, B, C, etc...
until yesterday when I noticed that the column headings are numbered 1, 2,
3,
etc... the same as the rows. I am not savy enough to write formulas for
this
format and need to change it back.

Does anyone know how to change this back to letters? I should also mention
that this problem has only occured in this particular workbook.

I look forward to receiving a reply and possible solutions :)