|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 8th, 2010, 06:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Method of viewing/naming columns or conversions for same
Hi. How does one change the way a sheet calls out the columns so that it is as a numeric form? Is it able to be sheet specific or does it require the entire workbook carry the same format? 
|
|
#2
May 8th, 2010, 07:29 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Method of viewing/naming columns or conversions for same
In EXCEL 2007:-
Office Button (top left hand corner) Excel Options (lower right hand corner) Formulas - make sure that there is a tick (check) in the box called:- R1C1 reference style It applies to the whole Workbook. If my comments have helped please hit Yes. Thanks. "Copacetic" wrote: Hi. How does one change the way a sheet calls out the columns so that it is as a numeric form? Is it able to be sheet specific or does it require the entire workbook carry the same format? .
|
|
#3
May 8th, 2010, 07:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Method of viewing/naming columns or conversions for same
In EXCEL 2003 and earlier....
Tools/Options on menu bar... General tab... Settings section... "R1C1 reference style" checkbox. Setting is global for the entire workbook. -- Rick (MVP - Excel) "trip_to_tokyo" wrote in message news  In EXCEL 2007:- Office Button (top left hand corner) Excel Options (lower right hand corner) Formulas - make sure that there is a tick (check) in the box called:- R1C1 reference style It applies to the whole Workbook. If my comments have helped please hit Yes. Thanks. "Copacetic" wrote: Hi. How does one change the way a sheet calls out the columns so that it is as a numeric form? Is it able to be sheet specific or does it require the entire workbook carry the same format? .
|
|
#4
May 8th, 2010, 11:07 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Method of viewing/naming columns or conversions for same
On Sat, 8 May 2010 14:44:12 -0400, "Rick Rothstein"
wrote: In EXCEL 2003 and earlier.... Tools/Options on menu bar... General tab... Settings section... "R1C1 reference style" checkbox. Setting is global for the entire workbook. I think there is some key combination that allows one to see the numbering in the 'names' field. Not sure what it is though.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
