Excel formula display formatting

[Staticfactory]

Probably a simple question but I can't find the answer...

Can the way a formula is displayed be changed? Specifically from relative to absolute? One of my users is very adamant about having the forumlas displayed as simple as possible (=A5+A1) rather than some relative structure where it's using (-4) to reference A1 from A5.

 

[Lilliabeth]

Are you using R1C1?

If so, you can turn it off at Tools > Options, General tab

 

[SkipVought]

Hi,

Tools/Options - General Tab -- uncheck R1C1 Reference Style

Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}

 

[Lilliabeth]

ooh, Skip I beat you this time!

 

[Staticfactory]

Sweet! I knew it would be simple!

Thanks for the quick reply Lilli and Skip.