I recommend that you download XLeratorDB and try this problem along with me, this is going to be a fun exercise and something new to learn about Business Days.
SQL SERVER – Preserve Leading Zero While Coping to Excel from SSMS
Want to preserve leading zero values when you paste SSMS results into Excel? The fix is in Excel: format the cells as Text first, and the zeros stay.
Copy Column Headers From SSMS Results to Excel
To copy column headers from SSMS results, use Copy with Headers or press Ctrl+Shift+C. This post also shows the Options setting that includes headers every time, why a change can seem to do nothing, and how to stop Excel from dropping leading zeros.
SQL SERVER – Excel Losing Decimal Values When Value Pasted from SSMS ResultSet
I often get questions that how to fix the issue where excel loses decimal values when values are pasted from SSMS Resultset.
Connecting Excel to SQL Server Safely
Connecting Excel to SQL Server safely means a narrow read-only view, a scoped login, controlled refresh load, and no saved password in the workbook.