Excel Column References

  • Thread starter Thread starter Nic Siddle
  • Start date Start date
N

Nic Siddle

My spread sheets have spontaneously switched from giving
column refs as letters to numbers. Instead of A, B, C etc
they now show 1,2,3..........

Why has this happened and, more to the point, how can I
correct it?

Thanks in advance for advice

Nic
 
<Tools> <Options> <General> tab,
*Uncheck* R1C1 reference style.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

My spread sheets have spontaneously switched from giving
column refs as letters to numbers. Instead of A, B, C etc
they now show 1,2,3..........

Why has this happened and, more to the point, how can I
correct it?

Thanks in advance for advice

Nic
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column headings 2
Cell References Format 2
Column Header is not in Letter 1
columns showing numbers instead of alphabets 1
Column heads are numbers 4
Showing Letters For Column Headers Rather Thann Numbers ? 1
Column Labels change 3
Columns are labeled as numbers in the grid!! 2

Back
Top