Excel removing zeros from SQL when copying data

All,

I need your assistance with copying data from SQL to Excel.

I have the following results from SQL server:
0.0059000
9999.0000
But in Excel I get this
0.0059
9999

How can I copy the data as is to Excel?

Many Thankls.
jose11auAsked:
Who is Participating?
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.

Ryan ChongCommented:
what's the tool or method you're using in "copying" the data from SQL Server to Excel?
0
jose11auAuthor Commented:
Hi,
I just right click on SQL Sever results grid and select either copy or copy with headers.

Thanks.
0
Ryan ChongCommented:
I don't have a SQL Management Studio with me right now, but for a quick fix, you can do the formatting in Excel instead.

Use Text Import Wizard
After you paste the values in excel, try click on the small paste icon, and then select the Use Text Import Wizard.

in Step 1 of 3, leave the selection of "Delimited", click Next.
in Step 2 of 3, leave it as it is and click Next.
in Step 3 of 3, select Text from column data format, and then click Finish.

Step 3 of 3
Will you satisfy this approach?
0

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
jose11auAuthor Commented:
Thanks so much. The above works.

Thanks.
0
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 SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.