columns are numerical insted of alphabetical
I have managed to change the alphabet columns to numerical. How can I change
this back. Rows are still numerical so both rows and coumns ar now 1....10,etc |
Chris, tools, options, general, uncheck R1C1 ref. style
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Chris" wrote in message ... I have managed to change the alphabet columns to numerical. How can I change this back. Rows are still numerical so both rows and coumns ar now 1....10,etc |
Hi Chris-
ToolsOptions--General, remove the R1C1 check. Regards |:) "Chris" wrote: I have managed to change the alphabet columns to numerical. How can I change this back. Rows are still numerical so both rows and coumns ar now 1....10,etc |
Worked a treat Paul. Thanks for your help. Fat fingers wreak havoc again.
"Paul B" wrote: Chris, tools, options, general, uncheck R1C1 ref. style -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Chris" wrote in message ... I have managed to change the alphabet columns to numerical. How can I change this back. Rows are still numerical so both rows and coumns ar now 1....10,etc |
All times are GMT +1. The time now is 02:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com