Open excel and then go to options in tools menu. In General uncheck the R1C1
reference style. Thats all. O.K.

"luvthavodka" wrote:

On opening up a spreadsheet sent to me today, the column names have changed
from letters to numbers - how do I revert back? I've never seen this before
and it makes inserting formulas quite difficult.

Eg Cell A1, is now called R1C1 (row1column1)

Have tried opening up a blank spreadsheet and importing, but new
spreadsheets are now opening up in this format also.