How do columns headings change from letters to numbers?
 

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 :)

How do columns headings change from letters to numbers?
 

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 :)

How do columns headings change from letters to numbers?
 

Click Tools Options General tab
Uncheck "R1C1 reference style" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jaime Keen" wrote:
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 :)

How do columns headings change from letters to numbers?
 

Thank you very much for your help.

"Max" wrote:

Click Tools Options General tab
Uncheck "R1C1 reference style" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jaime Keen" wrote:
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 :)

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 :)

How do columns headings change from letters to numbers?
 

Delighted, Jaime.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jaime Keen" wrote in message
...
Thank you very much for your help.