Forum Discussion

jjmagooo's avatar
jjmagooo
Copper Contributor
Feb 23, 2023

formulas

The object cell of a formula shows the formula rather than the product of the formula.
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Feb 24, 2023

    jjmagooo 

    IF the cell containing the formula is formatted as Text, change its number format to General, then press F2 to edit the formula, and press Enter to re-confirm it.

jjmagooo's avatar
jjmagooo
Copper Contributor
Thanks, but I clicked on Show Formulas and the formula still shows in the cell.
HansVogelaar's avatar
HansVogelaar
MVP
Feb 24, 2023

jjmagooo 

IF the cell containing the formula is formatted as Text, change its number format to General, then press F2 to edit the formula, and press Enter to re-confirm it.

  • jjmagooo's avatar
    jjmagooo
    Copper Contributor
    Feb 24, 2023
    The cell is formatted as Number but I entered the amount manually, then replaced it with a formula and it worked. Thanks again.

Share

Resources