Joe Smith wrote:
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.
snip
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
Hi Joe,
I wasn't looking for a reversal of the original process, but a quick way to
change data that's the wrong format. Many times, I'll be using a chunk of a
string to do a vlookup of imported data. Most of the time the data is in numeric
strings, but occasionally, it's numbers. Rather than modifying my formula, a
quick fix of the offending data gives me the result I want. Changing the cell
format hasn't always worked for me. I'm not dealing with any leading zeros, so
there's little chance for data loss.
tc
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
