13 July 2016

Excel Losing Decimal Values When Value Pasted from SSMS ResultSet


Remember to format cells to text in Excel, before pasting from the SQL Server Management results window.

This will keep the decimal format from SSMS as a dot and not autoformat the number and loosing the comma in the process.