Forum Discussion

hoacvxd's avatar
hoacvxd
Copper Contributor
Sep 11, 2022
Solved

Error displaying formulas in excel

I am using Office365 and often encounter formulas in some cells of the spreadsheet. As shown in the picture, cell AA7 shows the formula while the other cells don't, currently the position cursor is ...
excel
Formulas and Functions
Macros and VBA
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Sep 11, 2022

    hoacvxd I suspect the cells concerned are, perhaps accidentally, formatted as text. change the format to General, press F2 to enter the formula bar and press Enter to confirm the formula.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Sep 11, 2022

hoacvxd I suspect the cells concerned are, perhaps accidentally, formatted as text. change the format to General, press F2 to enter the formula bar and press Enter to confirm the formula.

  • hoacvxd's avatar
    hoacvxd
    Copper Contributor
    Sep 21, 2022
    This workaround only works temporarily, when the formula is updated this error occurs again.
    Is there any way to completely solve it?
    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Sep 21, 2022

      hoacvxd Don't understand. Can you share the file? Upload it in the Forum or share it via OneDrive or similar.

      • hoacvxd's avatar
        hoacvxd
        Copper Contributor
        Oct 20, 2022

        Riny_van_Eekelen 

        https://1drv.ms/x/s!AvHn5JC0SYHCkYF0mdtP3VSIbpZTSw?e=l6THDa 

        Please help me.

        Thanks.

  • hoacvxd's avatar
    hoacvxd
    Copper Contributor
    Sep 11, 2022
    Thank you.
    Your solution solved my problem.

Resources