Excel removing zeros from SQL when copying data

jose11au
jose11au used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Ryan ChongSoftware Team Lead

Commented:
what's the tool or method you're using in "copying" the data from SQL Server to Excel?
jose11au

Author

Commented:
Hi,
I just right click on SQL Sever results grid and select either copy or copy with headers.

Thanks.
Software Team Lead
Commented:
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?
jose11au

Author

Commented:
Thanks so much. The above works.

Thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial