[EMAIL PROTECTED] wrote:
Question regarding OO Calc spreasheet
Hi All,
I've got column B which displays numbers which are the result of a
formula. I would like column C to display the same number, but in text
format (as though I typed it in) so that no formula exists in the
cells of column C. This way I have a record of the original order of
column C.
Any way to do this?
Thanks,
Tom
Copy column A. Go to column B and select Edit > Paste Special. Check
everything except for Formulas; uncheck Formulas. Then click OK. That
should do it.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
