SQL SERVER – Excel Losing Decimal Values When Value Pasted from SSMS ResultSet
- by pinaldave
No!
It is not a SQL Server Issue or SSMS issue. It is how things work. There is a simple trick to resolve this issue.
It is very common when users are coping the resultset to Excel, the floating point or decimals are missed.
The solution is very much simple and it requires a small adjustment in the Excel. By default Excel is very smart and when it…