Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Headings Numeric
My column headings have changed from alpha to numeric. I do not know what I
did to change them, but can not find any direction to change them back..... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Headings Numeric
Pull-down:
Tools Options... General and clear the R1C1 checkbox -- Gary''s Student "Cindy Ru" wrote: My column headings have changed from alpha to numeric. I do not know what I did to change them, but can not find any direction to change them back..... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Headings Numeric
Check the answer to Q2 of the following page:
http://www.xldatasoft.com/qapage.htm -- Best regards, --- Yongjun CHEN ================================= XLDataSoft - Data Analysis Expert, Excel/VBA Specialist - - - - www.XLDataSoft.com - - - - Free Excel-Based Data Processing Tool is Available for Download Free Excel / VBA Training Materials is Available for Download ================================= "Cindy Ru" <Cindy wrote in message ... My column headings have changed from alpha to numeric. I do not know what I did to change them, but can not find any direction to change them back..... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Headings Numeric
Thanks so much. Do you know how this could have happened when I did not go
into tools and click that box? "Gary''s Student" wrote: Pull-down: Tools Options... General and clear the R1C1 checkbox -- Gary''s Student "Cindy Ru" wrote: My column headings have changed from alpha to numeric. I do not know what I did to change them, but can not find any direction to change them back..... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Headings Numeric
Excel picks up this setting from the first workbook you open in that session.
If you have a workbook that is shared between lots of folks, maybe one of them opened, changed that setting and then saved the workbook. And you just happened to open that workbook first. Remember that setting. You may find that you need to use it again. Cindy Ru wrote: Thanks so much. Do you know how this could have happened when I did not go into tools and click that box? "Gary''s Student" wrote: Pull-down: Tools Options... General and clear the R1C1 checkbox -- Gary''s Student "Cindy Ru" wrote: My column headings have changed from alpha to numeric. I do not know what I did to change them, but can not find any direction to change them back..... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Find Numeric Criterion in Column & Return the Numeric Value from Row above | Excel Worksheet Functions | |||
How do I take information in 1 column to make column headings? | Excel Discussion (Misc queries) | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions |