How to paste long numbers eg 210000000000026324 into Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CCF - 29 Mar 2007 05:12 GMT

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?

Reply to this Message

JE McGimpsey - 29 Mar 2007 05:19 GMT

One way:

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

> When pasting these numbers into Excel:
>
[quoted text clipped - 24 lines]
> Which is an absolute pain if i have to repeat this every time. Is there an
> easier way?

Reply to this Message