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.