Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Numeric Column Notation in EXCEL 2007
My EXCEL 2007 has switched to Numeric column notation and I can't switch find
how to switch it back to Alphameric. As it sits, cell designations must be written R1C1, R1C2 etc. rather than A1,B1 etc. HELP. I know this sounds simple but EXCEL 2007 is substantially different from earlier versions: There is no "tools" There is no "default." I need help to set it back. -- wwnexcelerator |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Numeric Column Notation in EXCEL 2007
Click the Office button (top left corner), choose Excel Options, Formula tab. There it is.
-- Kind regards, Niek Otten Microsoft MVP - Excel "wwells" wrote in message ... | My EXCEL 2007 has switched to Numeric column notation and I can't switch find | how to switch it back to Alphameric. As it sits, cell designations must be | written R1C1, R1C2 etc. rather than A1,B1 etc. HELP. I know this sounds | simple but EXCEL 2007 is substantially different from earlier versions: | There is no "tools" There is no "default." I need help to set it back. | -- | wwnexcelerator |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Numeric Column Notation in EXCEL 2007
Click the Office button and then the Excel Options button at the foot of the
dialog. From the Excel Options dialog select Formulas, and then the R1C1 reference style checkbox is in the Working with formulas section. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "wwells" wrote in message ... My EXCEL 2007 has switched to Numeric column notation and I can't switch find how to switch it back to Alphameric. As it sits, cell designations must be written R1C1, R1C2 etc. rather than A1,B1 etc. HELP. I know this sounds simple but EXCEL 2007 is substantially different from earlier versions: There is no "tools" There is no "default." I need help to set it back. -- wwnexcelerator |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Numeric Column Notation in EXCEL 2007
Thanks: I knew it had to be simple but there are so many new menus that
unless you know where to look it is like finding a needle. Still can't figure out what switched it to numeric notation. Thanks again. -- wwnexcelerator "Niek Otten" wrote: Click the Office button (top left corner), choose Excel Options, Formula tab. There it is. -- Kind regards, Niek Otten Microsoft MVP - Excel "wwells" wrote in message ... | My EXCEL 2007 has switched to Numeric column notation and I can't switch find | how to switch it back to Alphameric. As it sits, cell designations must be | written R1C1, R1C2 etc. rather than A1,B1 etc. HELP. I know this sounds | simple but EXCEL 2007 is substantially different from earlier versions: | There is no "tools" There is no "default." I need help to set it back. | -- | wwnexcelerator |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Numeric Column Notation in EXCEL 2007
<Still can't figure out what switched it to numeric notation
I always find this somewhat of a mystery. There are just too many posts about this happening to believe that one did this by accident. I think. Well..... I don't know! -- Kind regards, Niek Otten Microsoft MVP - Excel "wwells" wrote in message ... | Thanks: I knew it had to be simple but there are so many new menus that | unless you know where to look it is like finding a needle. Still can't | figure out what switched it to numeric notation. Thanks again. | -- | wwnexcelerator | | | "Niek Otten" wrote: | | Click the Office button (top left corner), choose Excel Options, Formula tab. There it is. | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "wwells" wrote in message ... | | My EXCEL 2007 has switched to Numeric column notation and I can't switch find | | how to switch it back to Alphameric. As it sits, cell designations must be | | written R1C1, R1C2 etc. rather than A1,B1 etc. HELP. I know this sounds | | simple but EXCEL 2007 is substantially different from earlier versions: | | There is no "tools" There is no "default." I need help to set it back. | | -- | | wwnexcelerator | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numeric column headers Excel 2007 | Excel Discussion (Misc queries) | |||
Find Numeric Criterion in Column & Return the Numeric Value from Row above | Excel Worksheet Functions | |||
Excel XP. column headings are numeric I want alpha | Setting up and Configuration of Excel | |||
Need to indirectly reference columns 26 using A1 notation based on numeric column number- how to? | Excel Worksheet Functions | |||
change excel column headings from numeric to alphabetical | Excel Discussion (Misc queries) |