| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
converted spreadsheet to 2007, column letters now numbers??
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
converted spreadsheet to 2007, column letters now numbers??
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
converted spreadsheet to 2007, column letters now numbers??
In 2007
Office ButtonExcel options Formulas Uncheck R1C1 style -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Linexe" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 changed the column Letters into numbers | Excel Discussion (Misc queries) | |||
| Total in Money Converted into Letters!!! | Excel Discussion (Misc queries) | |||
| How can I change column numbers back to column letters? | Excel Worksheet Functions | |||
| Return column letters to spreadsheet. | Charts and Charting in Excel | |||
| row numbers & column letters | Excel Discussion (Misc queries) | |||
Linear Mode
