Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i change column header from R[1] C format to A1 format?
I am not sure how to get the worksheet to show alpha in the columns and
formulas instead of numeric. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i change column header from R[1] C format to A1 format?
Hi,
Tools|Options - general tab and uncheck R1C1 -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "lovnlife" wrote: I am not sure how to get the worksheet to show alpha in the columns and formulas instead of numeric. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i change column header from R[1] C format to A1 format?
Hi,
Press CTRL + ~ ~ is at the right of number 1 "lovnlife" wrote: I am not sure how to get the worksheet to show alpha in the columns and formulas instead of numeric. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i change column header from R[1] C format to A1 format?
In XL2003 and earlier... Tools/Options from the menu bar, click General tab,
uncheck the first item ("R1C1 reference style"). -- Rick (MVP - Excel) "lovnlife" wrote in message ... I am not sure how to get the worksheet to show alpha in the columns and formulas instead of numeric. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i change column header from R[1] C format to A1 format?
And for XL2007, click Office Button, Excel Options Button, select Formulas
from the left hand listing and uncheck "R1C1 reference style" in the "Working with formulas" section in the right hand listing. -- Rick (MVP - Excel) "Rick Rothstein" wrote in message ... In XL2003 and earlier... Tools/Options from the menu bar, click General tab, uncheck the first item ("R1C1 reference style"). -- Rick (MVP - Excel) "lovnlife" wrote in message ... I am not sure how to get the worksheet to show alpha in the columns and formulas instead of numeric. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the default header date format in Excel 2007? | Excel Worksheet Functions | |||
Column header format | Excel Discussion (Misc queries) | |||
Change Format of Date in Header | Excel Worksheet Functions | |||
Excel 2003 can you change the header date format? | Excel Discussion (Misc queries) | |||
how do I change date format in the header in Excel XP ? | Excel Discussion (Misc queries) |