G Guest Jun 11, 2007 #2 The only way would be to use conditional formatting. Click "Format/Conditional Formatting" and enter your conditions and formats.
The only way would be to use conditional formatting. Click "Format/Conditional Formatting" and enter your conditions and formats.
N Niek Otten Jun 11, 2007 #3 Enter the formula. Format>Cells>Custom, 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 | How do I enter a formula in a text cell without changing the text?
Enter the formula. Format>Cells>Custom, 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 | How do I enter a formula in a text cell without changing the text?
