Anthony Chilco wrote:
... I had to try to reverse the process by entering '& in the replace
box. This will turn numbers into strings.
I'm not sure I understand what you were trying to do, but just to be
clear: the trick is not (necessarily) reversible. The reverse method you
mentioned will change numbers to strings, but you can definitely lose
data this way.
If a cell contains '08003 (i.e. a numeric string) and you run the Find &
Replace trick, it will become a numeric value with the value 8003. If
you reverse the trick, it becomes '8003, which is not the same as you
started with.
Edit > Undo is your only friend here ;-)
If I were using these tricks, I would select the data to change, and
then set Find & Replace > Options / Current selection only = YES, just
be sure I didn't change something inadvertently.
Also, the F&R trick will not change types against the cell format. If a
cell has a 'Text' format, it will not magically change to a number.
<Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
