Search and replace - simple question, i hope!
Posted by Dave on February 05, 2002 6:13 AM
I hav OCR'd lots of data and the format of the original is "XXX." or "YYY.YY" mixed up in the same column.
Is there a way to search for the cells which end with a decimal point and replace them with ".0" so i end up with "XXX.0" and "YYY.YY" without affecting the "YYY.YY" values?
Put simply (!?!) i want to append 0's to those data which don't already have them.
Cheers in advance for your help,