My spreadsheet shows 1, 2, 3... instead of A, B, C, for columns

C

Culleoka

Suddenly my excel spreadsheets went from normal -- displaying numbered rows
and alphebetized columns, to displaying numbered rows and columns, even in
spreadsheets I had previously created. The formulas in the cells look
completely crazy, which I assume is a by-product of this problem. For
example =R[-2]C[-1]*RC[-1]. Which should read =G28*G30. I have no idea how
to fix this. Help.
 
C

Culleoka

Thank you!!! That was exactly it! Not sure how that box got checked, but I
won't worry about that for now.

Peo Sjoblom said:
Tools>options>general and clear R1C1 reference style

--


Regards,


Peo Sjoblom

Culleoka said:
Suddenly my excel spreadsheets went from normal -- displaying numbered
rows
and alphebetized columns, to displaying numbered rows and columns, even in
spreadsheets I had previously created. The formulas in the cells look
completely crazy, which I assume is a by-product of this problem. For
example =R[-2]C[-1]*RC[-1]. Which should read =G28*G30. I have no idea
how
to fix this. Help.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why did my columns change from being headed A, B, C to 1, 2, 3? 2
Problem with Column header ID being 1 2 3 etc instead of A B C etc 2
Find partial match from column A,B and fill partial match in C? 4
Why are my columns numbered instead of lettered? 6
Problem with named range for a large spreadsheet in Excel 2007 0
excel-why do the columns A B C D etc and 1 2 3 4 etc print? 2
Column showes 1 2 3 instead of A B C 1
Change all instances of A,B,C,D to G 4

Top