What does a + sign do when referencing a cell?

[adamsad1]

I am modifying a workbook. Whoever developed it uses a + sign prior to referencing a cell on another sheet. Ex,

=+'Sheet 1'!A1

What does the plus sign do? I've never seen that before.

[Paul]

Hi Adam,

I believe that person probably used Lotus in the past, as that is very common. It's still valid as a shortcut to typing = in Excel.

If you select a cell (for example, B1) and type +A1 it is the same as typing =A1 and will appear as =+A1. It shouldn't affect anything in your formulas, though.

[arthurbr]

But is does make the formulas more impressing

[adamsad1]

Ah. Thanks!