How to paste long numbers eg 210000000000026324 into Excel

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
One way:

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