How to paste long numbers eg 210000000000026324 into Excel

C

CCF

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

Similar Threads

Embed the same Excel multiple times 0
Excel does not accept text format! 0
Paste to excel from word - auto format problem 1
How can the font and size of (all) citation numbers be altered? 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
How to change font & size of (all) citation numbers? 7
Time Sum in Excel 1
Excel 2007 paste data, need to convert to numbers 3

Top