I get spreadsheets with 1,000 15 digit numbers with a letter added on the end. I can retain the number by formatting the cells to Text and then remove the letter manually and it's fine. BUT if I use the Find/Replace mode to remove the letter, it converts the 15 digit number to that exponential format (is that what its called?).
Anyone know how I can efficiently replace this letter with 'blank' and retain the 15 digit number?
-> I want it to