converted spreadsheet to 2007, column letters now numbers??

  • Thread starter Thread starter Winnie K
  • Start date Start date
W

Winnie K

In a spreadsheet converted to version 2007, the column letters changed to
column numbers. The rows and columns are now identified with numbers. I
have never seen this in a spreadsheet and am wondering if this can be
converted back and why it happened.
 
Hi

This is done through the set up of your spreadsheet

in Excel click on Tools
Then Option
On the "General Tab" make sure that there in not a tick in the R1C1
option and that should change the spreadsheets back

Linexe
 

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

Showing Letters For Column Headers Rather Thann Numbers ? 1
Columns now numbers rather than letters how do i get letters back 2
Column headings 2
Colunmn headers 4
Mulitple Listing of items within the single mail merge letter 5
changing column letters to numbers , etc. 3
why are my column headers numbers instead of letters? 2
view of page 2

Back
Top