Forcing Cell Format to GENERAL?

Question

If cell format is TEXT when entering a formula, then changing format to GENERAL does not change the result.

Is there a way to force Excel to update to the General format?

EXAMPLE

The cel isl formatted as TEXT when this formula is entered:

=OR($D10=data!$A$27,demo!$D10=data!$A$28)

The result is the display of that formula itself.

If I then change the cell format from TEXT to GENERAL, Excel still displays the formula as a formula.

If I delete all the cell content; then change the format to GENERAL, then reenter the same formula, Excel displays the results of that formula.

Answer 1

In Excel for Windows this is working also like this

After you change it to general and use CTRL u (F2 in windows)and press enter in will be a formula

Answer 2

THANKS SO MUCH.