Strange copy & paste behavior

D

Doug Kanter

I've got a spreadsheet which includes a list of numbers like the one below.
But, some contain a letter in the middle. They're warehouse location
identifiers - never used for math:

6074
6075
7008
7030
07D08
07D30
07D84
07F08
07F30


Today, I needed to create a text file for another program to use. So, I
opened a new sheet, formatted all target cells as text, and copied the list
of numbers to the new sheet using Paste Special, Values. The identifiers
which contain a letter vanished. The new sheet had NOT been saved as a text
file at that point - it was still just a new, unnamed Excel sheet. Is Excel
seeing those values as hex, or......what? I've never seen anything like
this.
 
B

Bryan Hessey

Sounds like you did a Paste Special Values Add, untick the Add and tr
again.

HTH

--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA: How can I use a string variable as autofilter criteria? 4
Strange Copy/Paste behavior 3
Problem with CSV file 6
Copy and Paste 2
I can't copy and paste equations 0
How to Display 12.5 but not 25.0 (drop .0’s) 5
Copy and paste special - values into new excel file 1
Formatting not protected when paste 7

Top