xladept, Thank you very much.
Your code works but is working on cells with leading zeros. Many of the values in column H are below 1 decimal values with leading zero's, so it is returning some strange results. I need this to only work on cells that only have a single zero, and return values of like kind, single decimal place values.
Bookmarks