Pasting large numbers as text in Excel

S

Sian

My input call is formatted as text. However when my users try to paste large
(20 digit) numbers into it (copied from outlook email) these paste in as
scientific notation and the cell format changes to general. This also
happens using any option in Paste Special.
I'm sure I'm missing something simple, but what?
Many thanks, Sian
 
D

Dave Peterson

If the cell is already formatted as Text, then have them paste directly into the
formula bar.
 
S

Sian

Ok, this almost works (thank you!). Next problem: paste 6006491199999999999
and it replaces the last four 9s with 0s. Any ideas?
 
C

cmarion

Format cell as text, then copy in Outlook, use Edit-Paste Special-Text in
Excel. This should work
 
C

cmarion

Format cell as text, then copy in Outlook, use Edit-Paste Special-Text in
Excel. This should work
 

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

large numbers as text replaced with scientific notation 2
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Excel reading pasted values as Scientific Notation 3
Changing Text To Numbers ? 1
Error with copying values in cells 2
Formatting numbers 1
Number Formatting help 3
don't want cell numbers to change when pasting formulas 3

Top