Excel Formula Hack: Start Formulas With A Symbol!

Check out @ExcelCampus for more Excel tutoring tips, including more formula hacks, VBA and macro tutorials, beginner to advanced level Excel training in Pivot Tables, and overviews of the Excel "Power Tools" (Power Query, Power Bi etc.)

[Nuggets_Of_Dino]

This explains why I can't simply enter + as text at the start of a cell

[krimbos]

I have always used + sign to enter formulas. Lately I have noticed it can lead to problems when copying cells

[michaelkuhn]

Old time spreadsheet use here - I think I remember using @ to start formula in Lotus, such as @sum(a1..a3).

[aloobi]

I always use plus because the plus sign key is bigger and easier to find on a typical keyboard. People keep asking me why I do that. I once did a test to see its impact on the file size. No impact. If I remember correctly, the file size was actually smaller.

[entireazerbaijanentireazer]

Perfect! Just would like to know what software you use to record your screen. if possible

[LG-lobc]

Love the Twin Peaks Easter Egg d$2)m good pie 🥧

[FilmscoreMetaler]

My predecessor used this absolutely everywhere. Took me years to get rid of each instance of "=+" in every excel file. I can't stand redundancies in my formulas.

[danyos]

Does the plus sign could affect advance setups such as calculations, VBA codes, pívot tables, or dashboards?

As a user accustomed to using keyboard short cuts, I’d like to use the plus sing instead of the equal, but I’m concerned it could affect something.

[icarusflying]

I start formulae with a + or - because those exist near the number pad section of the keyboard and = is next to backspace.

Nothing to do with Lotus123

[mrhoneystinger]

I used to work with lotus 1-2-3 and Lotus Notes.
Formulas in Lotus began with an @
Example @sum(a1:a10)

Subsequently in Lotus you could create formulas like +123+123 instead of =123+123

[jacquiblue]

why would you do this instead of just =