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?