Thread: Formula typed but not evaluated
View Single Post
 
Old 10-05-2018, 11:38 PM
ArviLaanemets ArviLaanemets is online now Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
1. Check the format of cell with formula - when Text then change to General;
2. Press F9. When the formula calculates, then you have calculation set to "Manual calculation". Set calculation to "Automatic"
Reply With Quote