I've changed the way my formulas are displayed !!

D

Dave

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
 
D

Dave Peterson

Tools|Options|General Tab|Uncheck R1C1 Reference style
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
Click to expand...
 
F

Franz Verga

Dave said:
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].
Click to expand...

Any help with getting my formulas to look how they used to would be
gratefully appreciated!!!

Thanks in advance

Dave
Click to expand...

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
 
D

Dave

Dave, Franz, & Nobody, Thanks for your quick replies.

You are all stars

Cheers

Dave
 
Top