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

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

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

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

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