Sep 13 2021 01:32 AM
Goodmorning everyone,
I have a problem.
In an "A" sheet of excel I have a cell formatted as "GENERAL", inside there is a formula linked to another "B" sheet.
When I make a copy of sheet "A" and change the link to sheet "B" this cell is automatically formatted as "TEXT".
I would like to prevent this automatism.
Could you help me please?
Thanks
Sep 13 2021 04:12 AM
Click File > Options.
In the Excel Options box, click Proofing > AutoCorrect Options.
Check more details below
Sep 13 2021 05:55 AM
Thanks for getting back to me so quickly.
I use office 2019 pro plus in Italian.
I looked in the "Proofing" options (which in Italian translates to "Strumenti di correzione") and after clicking in the "AutoCorrect Options" box I disabled the various items one by one but the problem was not solved.