http://blog.sqlauthority.com/2012/09/24/sql-server-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.
No comments: