I have a column in spreadsheet set to 'text' format that looks like this: xxxxxx057483245
I am attemtping to replace the x's with another series of numbers. 42424242 for example.
I go to find and replace, and enter in the 6 x's to be replaced by the new numbers. The result I get in the replaced column is 4242424057483240. Note the 5 has been replaced with a 0.
I have attempted to play around with the column formatting trying to use text, general and number with 0 decimal places with no luck. Any ideas? I know how to get around it, but thought I should try and seek the answer for posterity.