Excel Type 1 formula

If you edit an Excel Type 1 formula, the formula is not converted into another formula type.

If you want to convert an Excel Type 1 formula to an Excel Type 2 formula, delete the cell contents before specifying a new formula.