formulas
 

How do I enter a formula in a text cell without changing the text?

formulas
 

The only way would be to use conditional formatting.
Click "Format/Conditional Formatting" and enter your conditions and formats.
--
Pops Jackson


"fitou_learn" wrote:

How do I enter a formula in a text cell without changing the text?

formulas
 

Enter the formula. FormatCellsCustom, in the Type box, enter "text"
(replace text with your text)

If this is not what you mean, tell us what you're trying to achieve

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"fitou_learn" wrote in message ...
| How do I enter a formula in a text cell without changing the text?