ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column Headings Numeric (https://www.excelbanter.com/excel-discussion-misc-queries/91461-column-headings-numeric.html)

Cindy Ru

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.....

Gary''s Student

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.....


Daniel CHEN

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.....




Cindy Ru

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.....


Dave Peterson

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


All times are GMT +1. The time now is 06:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com