Adrian Try wrote:
Hi Harold
I want to make the
"September 17" in B1 *text* instead of the result of a formula, so
that it no longer depends on A1.
How? Please
Point to cell B1, and copy it to the clipboard (Edit/Copy). While
leaving the cursor in B1, select Edit / Paste Special.
Untick Paste All and Formulas, and press OK. B1 should now be text.
Hope this helps!
Adrian
Adrian,
It does. Thank you.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
