How to paste long numbers eg 210000000000026324 into Excel

G

Guest

When pasting these numbers into Excel:

210000000000026324
210000000000026524
210000000000023324

The pasted numbers appear as:
2.1E+17
2.1E+17
2.1E+17

and the values change to

210000000000026000
210000000000026000
210000000000023000

I have tried:
1. change the format of the cells to Text, this still happens.
2. paste as unicode

Nothing seems to work other then changing each number to
="210000000000026324"
="210000000000026524"
="210000000000023324"

Which is an absolute pain if i have to repeat this every time. Is there an
easier way?
 
J

JE McGimpsey

One way:

Preformat the destination cells as Text, then use Edit/Paste
Special/Text to paste.
 

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

Top