SQLTeam.com | Weblogs | Forums

Comma and dod problem with sql and excel


when i execute the tsql,i wanna copy result and paste excel sheet but the numbers had problem.
for example in sql 4.2900 bu when i copied excel 42.900
can you help this problem pls


Are you saying that Excel shifts the decimal point one place to the right? Hard to believe. Please post some screen shots


I don't have any ideas on why the data is shifted by ONE decimal place either. The only thought that comes to mind is some type of custom formatting in the Excel cells that you are pasting to.

If the Excel cell is formatted as percentage, when you paste a number such as 4.2900, it would show up as 429.00% But that is two decimal places.