Avoid automatic format change

Copper Contributor

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

2 Replies

@MaXuS_it 

 

  1. Click File > Options.

  2. In the Excel Options box, click Proofing > AutoCorrect Options.

Check more details below

Removing Auto Formatting 

@Juliano-Petrukio 

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.