MrExcel Publishing
Your One Stop for Excel Tips & Solutions

last digit of phone number increased by one for duplicate records

Posted by Kim Ennis on October 19, 1999 8:52 AM

Hi everyone,
A co-worker of mine had a column of phone numbers which were somehow copied into another worksheet (unfortunately I don't know how he brought the numbers in). In the new worksheet, where the record was a duplicate, the second instance of the phone number was modified automatically - the last digit was increased by one. Not for every duplicate record although, and I couldn't see the pattern. All the cells involved with phone numbers were formatted General. We've gone ahead and made corrections manually, but are still scratching our little novice heads... any ideas? Thanks! Kim

Posted by Chris on October 19, 1999 9:22 AM


If the duplicate records only had one phone number listed, someone may have copied that formula down to the next cell to fill it in. If this one done by dragging the fill handle down to the next cell, it would increase by one. If was copied, then pasted it would not. This is the only explanation that I can think of.


Posted by Kim on October 19, 1999 9:56 AM

Thanks Chris - once I read your reply, I remembered I had used this function before...I'm still waiting to talk with the person who did it, to see what they did... interesting however... when we corrected it, we dragged the correct number up to the cell above it and it copied the value exactly (when I tested this out, it decreased the number, unless I held down Control when release the drag...). Well, thanks for your help!

btw, if you or anyone else can tell me the best method for achieving what was trying to be done, I'd be happy to learn more! Thanks!