converted spreadsheet to 2007, column letters now numbers??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Winnie K - 28 Mar 2008 16:58 GMT

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.

Reply to this Message

Linexe - 28 Mar 2008 18:29 GMT

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

Reply to this Message

Ron de Bruin - 29 Mar 2008 19:57 GMT

In 2007
Office Button>Excel options

Formulas
Uncheck R1C1 style

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> Hi
>
[quoted text clipped - 6 lines]
>
> Linexe

Reply to this Message