Joe Smith wrote:
Gene Young wrote:
Joe Smith wrote:
...
Note: The cell format does not determine whether a cell holds a
numeric value or a text value. That is determined by Calc's
examination of the data when it is entered, and /nothing/ after will
change its value type.
Actually you can change it by editing the cell and removing the
apostrophe. Try it.
You're right--what I wrote wasn't very clear. Sorry.
I didn't mean that the type of a value can never change, I meant that
the only circumstance where the type can change is when the value is
entered.
And from Calc's point of view, editing a value is no different than
entering a value. Either way, when you press Enter, Calc looks at the
input and decides whether the input is text or numeric.
So, for clarity, I should have written: .../nothing/ after will change
its value type, other than a new data entry.
Anything that causes Calc to re-examine the input can cause the value
type to change, including a search and replace--even a search and
replace that doesn't change the value at all.
OTOH, changing the cell formatting will never change the value's type,
even though it may change the value's appearance.
<Joe
I figured you knew this. I was just concerned that the OP might get
discouraged by the way you originally worded it and just give up.
--
Gene Y.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
