When I paste numbers in to cells why do strange things appear?

G

Guest

I need to paste (10 digit) numbers into cells in Excel documents. However
when I do so, something like 1.7001E+11 appears. I have to manually reformat
each cell to a number then in order for it to appear correctly. I
highlighted the entire column and formatted it to being a number first, but
that doesn't matter. Any help would be appreciated.
 

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

Numbers as Text 1
numbers appear different after hitting enter 3
How to keep "text" number from changing to date.... 2
Changing Text To Numbers ? 1
Numbers appear as ##### instead of the actual number, how to fix? 1
Excel deleting some numbers from an excel document 1
Date and Number cell formats 4
how do i link cells that contain text in excel 3

Top