Pasteing in a 17 digit number as text

  • Thread starter Thread starter Krissysteen
  • Start date Start date
K

Krissysteen

I am trying to paste in a column of ID's that are 17
digits. I want it to paste in as text, yet no matter what
I do it changes the last two digits to zeroes
 
Hi
try formating the target cells as 'Text' before you paste the values
 
I've copied the data from another software program into
clipboard. When I do a paste or a Paste Special as
unicode text or text it still converts number to a
scientific number and changes last two digits to zeroes.
 
Hi
also after formating the cells first and pasting the data as values?
 
Oh!! Format first! I see what you are saying. Thanks that
works!!!

Kristine
Iowa
 
Hi Kristine
good to hear it works for you and thanks for the feedback :-)
 
You must log in or register to reply here.

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

using the =page! feature to transpose a row to column 0
How do you change single digits to recognized double digits? 6
cell format in Excel 2002 SP3 will not accept long numbers 1
15+ digit numbers 3
Adding a zero to the front of numbers 5
Edit Replace the third digit only of a number 3
Time format 4
Select 3/4 digit numbers from text 1

Back
Top