Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column numbers
Hello,
My column headers are showing as numbers, not Letters. That is, Cell A1 is actually R1C1 Is there an easy way to switch this back? Glen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column numbers
Tools==Options==General--Settings and turn off R1!C1 reference style.
"gmunro" wrote: Hello, My column headers are showing as numbers, not Letters. That is, Cell A1 is actually R1C1 Is there an easy way to switch this back? Glen |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column numbers
I tried that first. Now to change it back, I get a pop up window that
says Name Conflict Name cannot resemble a reference. Old Name F27 New Name (Input box) I don't know how to get past this. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column numbers
In the original spreadsheet there must a Named Range called F27 which when
you convert to the new (A1) format it thinks is a cell reference (F27) and hence an invalid name. When the input box appears, just enter another name e.g. CellF27 and hit OK. This will solve the problem. You can then rename CEllF27 to what ever you want. (I tried this and it works OK for me). HTH "gmunro" wrote: I tried that first. Now to change it back, I get a pop up window that says Name Conflict Name cannot resemble a reference. Old Name F27 New Name (Input box) I don't know how to get past this. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column numbers
Perfect, thanks
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert a column of positive numbers to negitive numbers | Excel Worksheet Functions | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
Can I change a column of calculated numbers to absolute numbers? | Excel Discussion (Misc queries) | |||
Changing column of numbers made of formulas to just numbers | Excel Discussion (Misc queries) | |||
Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions |