Format changes from "General" to "Text"
 

A cell has a "General" format, the cell contains a formula and the
result of the formula is displayed in the cell.

When I change an expression in the formula, the cell's format changes
to "Text" and the formula is displayed in the cell.

I then have to change the cell's format back to "General" then press
F2 to get the formula's result to be diplayed in the cell.

How can I prevent the cell's format from changing from "General" to
"Text"?

Format changes from "General" to "Text"
 

What is your formula and what exactly do you change? You didn't delete the =
sign by accident, did you?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"GARY" wrote in message
...
A cell has a "General" format, the cell contains a formula and the
result of the formula is displayed in the cell.

When I change an expression in the formula, the cell's format changes
to "Text" and the formula is displayed in the cell.

I then have to change the cell's format back to "General" then press
F2 to get the formula's result to be diplayed in the cell.

How can I prevent the cell's format from changing from "General" to
"Text"?

Format changes from "General" to "Text"
 

You can't.

Excel likes to help and sometimes that help isn't wanted.

Other times it is--like when you have a formula that retrieves a date.

GARY wrote:

A cell has a "General" format, the cell contains a formula and the
result of the formula is displayed in the cell.

When I change an expression in the formula, the cell's format changes
to "Text" and the formula is displayed in the cell.

I then have to change the cell's format back to "General" then press
F2 to get the formula's result to be diplayed in the cell.

How can I prevent the cell's format from changing from "General" to
"Text"?

--

Dave Peterson