BR><BR>It is of course, generally preferable to use a barcode scanner to input 20-digit number strings ... Excel from 'converting' the format to scientific notation? Changing the value type to ...

You can separate numbers from text in Excel ... Open the Excel file that contains the garbled data. Take a good look to see where the data has been placed. Long strings of data may appear to ...

If you want to parse strings ... the number and the labels, and she had 700 rows of data. Fortunately, I was able to come to my coworker’s rescue by showing her how to use Excel’s Text To ...

you probably don't care about these individual strings, so you can safely remove the hyphens. Use text processing functions to remove the hyphens in Excel and preserve the actual numbers.