| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I've changed the way my formulas are displayed !!
Hi All,
Not sure what i've done or how i've done it but my formulas have changed appearance !! for exaple a straight forward sum A1-A2+A3 now looks like this : RC[-3]-RC[-2]+RC[-1]. Any help with getting my formulas to look how they used to would be gratefully appreciated!!! Thanks in advance Dave |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I've changed the way my formulas are displayed !!
Tools|Options|General Tab|Uncheck R1C1 Reference style
Dave wrote: Hi All, Not sure what i've done or how i've done it but my formulas have changed appearance !! for exaple a straight forward sum A1-A2+A3 now looks like this : RC[-3]-RC[-2]+RC[-1]. Any help with getting my formulas to look how they used to would be gratefully appreciated!!! Thanks in advance Dave -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I've changed the way my formulas are displayed !!
Dave wrote:
Hi All, Not sure what i've done or how i've done it but my formulas have changed appearance !! for exaple a straight forward sum A1-A2+A3 now looks like this RC[-3]-RC[-2]+RC[-1]. Any help with getting my formulas to look how they used to would be gratefully appreciated!!! Thanks in advance Dave Menu Tools, Options, General tab, uncheck Reference style R1C1 (or something similar...). -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I've changed the way my formulas are displayed !!
Tools | Options | General | Uncheck R1C1 Reference Style
mama no teeth "Dave" wrote: Hi All, Not sure what i've done or how i've done it but my formulas have changed appearance !! for exaple a straight forward sum A1-A2+A3 now looks like this : RC[-3]-RC[-2]+RC[-1]. Any help with getting my formulas to look how they used to would be gratefully appreciated!!! Thanks in advance Dave |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I've changed the way my formulas are displayed !!
Dave, Franz, & Nobody, Thanks for your quick replies.
You are all stars Cheers Dave "Dave" wrote: Hi All, Not sure what i've done or how i've done it but my formulas have changed appearance !! for exaple a straight forward sum A1-A2+A3 now looks like this : RC[-3]-RC[-2]+RC[-1]. Any help with getting my formulas to look how they used to would be gratefully appreciated!!! Thanks in advance Dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
| Formulas go away | Excel Worksheet Functions | |||
| Copying Formulas | Excel Discussion (Misc queries) | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
| changed fonts are not displayed | Excel Discussion (Misc queries) | |||
Linear Mode
