disable mathematical signs

[max_max]

Hello,
you can in a given range disable "=" or "+" or "-"?
Every time I insert one of these signs excel creates a formula.
max_max

[FDibbins]

type ' in front of it, or format those cells to TEXT

[max_max]

I tried several times.
I write = and I click on the next cell (for example) excel write = B2
max_max

[FDibbins]

my 1st suggestion works. start by typing '

[max_max]

Appunti02.jpgAppunti01.jpg

[FDibbins]

no.
1st, type in ' then type in your sign. Do this directly IN the cell you are working with

[max_max]

Appunti04.jpg
max_max

[FDibbins]

Yes, correct, then just continue typing - after that - what you want

'=

[max_max]

Thanks Fdibbins,
you can create a custom text format for the sign < ' > to automatically insert?
max_max

[MrShorty]

Going with FDibbins other suggestion, you can preformat these cells as text, and that should stop Excel from seeing these as formulas. The formatting needs to be done before data entry.

[FDibbins]

Thanks Fdibbins,
you can create a custom text format for the sign < ' > to automatically insert?
max_max

Formatting is purely cosmetic and does not actually exist (or show up) IN the cell. You need to actually type in the ', so I dont think custom formatting will work

If you format the cells/range as text before-hand, then the only problem you should have is if you type = (with nothing else, and no enter), and then click on the next cell - then excel will think you are making a formula