Excel will attempt to convert numeric text into numbers....UNLESS you pre-format the destination range as text.
• Select the destination range or column
• Home.Number_section....Select: Text from the dropdown
Then, Home.Paste.Paste_Special.Text
Is that something you can work with?
Bookmarks