Forum Discussion
hoacvxd
Sep 11, 2022Copper Contributor
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 ...
- 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
Sep 11, 2022Platinum Contributor
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
Sep 11, 2022Copper Contributor
Thank you.
Your solution solved my problem.
Your solution solved my problem.