Excel formula displays formula rather than result
Fresh3 days ago
Mar 15, 202624591 viewsConfidence Score0%
0%
Problem
I am copying and pasting a formula in excel and instead of showing the value it is just displaying the formula. (the formula is ='G:\Corporate[NewOrder.xls]Sheet1'!Q21 ). Is there some setting that I need to change? I have tried the f9 key but it does not recalculate. It seems like sometimes when I…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Excel formula displays formula rather than result
Low Risk
Edit your formula and be sure there isn't a before the sign. The cell may have been formatted as text before the formula was entered. Select the cell, then right-click and select Format Cells. Format the cell as General (on the Number tab), then cli…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix