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
 
Back
Top