Excel Formula Hack: Start Formulas With A Symbol! 

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

Thanks so much for the new topic!..

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

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

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.

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.

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

My era program Lotus 123

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

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

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.

❤❤❤

why would you do this instead of just =

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