Excel copy & paste

Hi, I use Windows XP and am having a BIG problem trying to simply type in a string of 17 zip codes separated by a comma. I have tried merging the cells, formatting the cells for zip codes, for text, and for general.  I've even tried typing the numbers on Microsoft Word and used copy and paste, used Special Paste and sometimes I see all 17 sip codes on the worksheet but the minute I hit return I get a bunch of #######  and the description above shows this;
7.70087701877038E+84.

I really need to get this done, can someone please help. Thanks
camtzAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott CraigWebmasterCommented:
You want to first format the cell as text.  Type in the string of numbers and hit enter.  You should now see that it doesn't say the above things.  If that doesn't work, type in the zip codes, but in front of the entire string type a single quote (') and you should be good to go.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
wabashbdwCommented:
If text is OK, you could just type:
="zip1,zip2,etc"
netballiCommented:
Hello,

All numbers are stored internally by Excel as 15 digit floating-point numbers. If you want more than 15 digits you have to use Text rather than numbers, and so you will not be able to do arithmetic calculations with the number. You can make Excel store the number as text by putting an ' before it, or by formatting the cell as Text.
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

camtzAuthor Commented:
sgroppenbecker: - WOW !!!!!! - DONE.  I first tried to use the = sign and got a message that it did not like the commas.  I then used your suggestion (') and it accepted it.  Could you please tell me what this sign represents.  I've never used it.  Also, when I went back to click on the cell I had been using, I noticed something I've never seen before.  Up on the top left it said OLE_LINKI and even though I tried to unformat it, it still shows up that way so I used a different cell and it worked just fine.  Thanks much for your help.
netballiCommented:
hello,

The ' is an apostrophe sign used to indicate the value in cell is a text value and should not be interpreted as number value. make sure you are aware that you cannot use the value of these cell for any mathematical calculation.
camtzAuthor Commented:
Many thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.