jose11au
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks so much. The above works.
Thanks.
Thanks.