change headers from letter to number/number to letter

L

lazybee

I have a worksheet that has numbers in the column headings as opposed to
numbers, how can I change back to numbers?
 
B

Biff

Hi!

If you have numbers as the column headers, as opposed to numbers, then
there's no need to change them back to numbers! <g>

Goto Tools>Options>>General

Uncheck R1C1 reference style

Biff
 
Top