Forum Discussion

MaXuS_it's avatar
MaXuS_it
Copper Contributor
Sep 13, 2021

Avoid automatic format change

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

excel
Formulas and Functions

2 Replies

  • Juliano-Petrukio's avatar
    Juliano-Petrukio
    Bronze Contributor
    Sep 13, 2021

    MaXuS_it 

     

    1. Click File > Options.

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

    Check more details below

    https://support.microsoft.com/en-us/office/undo-automatic-formatting-in-excel-54eba206-110c-445a-89f1-c4eb67a36bd4 

    • MaXuS_it's avatar
      MaXuS_it
      Copper Contributor
      Sep 13, 2021

      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.

       

Resources