asked on 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.
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.
Microsoft SQL ServerMicrosoft SQL Server 2008Microsoft SQL Server 2005Microsoft Excel
Last Comment
jose11au
what's the tool or method you're using in "copying" the data from SQL Server to Excel?
ASKER
Hi,
I just right click on SQL Sever results grid and select either copy or copy with headers.
Thanks.
I just right click on SQL Sever results grid and select either copy or copy with headers.
Thanks.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks so much. The above works.
Thanks.
Thanks.