Column Heading problem

[Terence]

Hi,

I didn't change any setting in my Excel but all the column
identifiers have all changed to numbers. Column "A"
changed to "1", Column "B" changed to "2"....and so on.
Does anyone know why? How to change back to original
setting?
Thanks.

Terence

 

[Niek Otten]

Tools>Options>General, uncheck R1C1 Reference style

 

[Terence]

Thanks a lot!

-----Original Message-----
Tools>Options>General, uncheck R1C1 Reference style

--
Regards,

Niek Otten
Microsoft MVP - Excel




.