column heading

kees van Zonneveld

New Member
Joined
Jan 23, 2004
Messages
1
Hi,

Why is it that when I open some excel files the columns have numbers, while when I open other (old) files they have letters. It's very confusing in making formula's....

Please help me how to format this column heading.

Kees
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Iridium

Well-known Member
Joined
Jul 15, 2002
Messages
2,831
Welcome to the Board!

Go to Tools>Options-General tab and uncheck the R1C1 reference style check box

HTH
 

Watch MrExcel Video

Forum statistics

Threads
1,111,596
Messages
5,541,154
Members
410,543
Latest member
ExcelGlenn
Top