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.

<Tools <Options <General tab,
And *Uncheck*
R1C1 Reference Style
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"luvthavodka" wrote in message
...
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.

toolsoptionsgeneralsettingsr1c1 unchecked

--
Don Guillett
SalesAid Software

"luvthavodka" wrote in message
...
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.

goto
<tools<options<general<un-check "r1c1"

--
Greetings from New Zealand
Bill K
"luvthavodka" wrote in message
...
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.

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.