I am exporting some data from a view to an excel file though a DTS. $0 amounts come as -0, what is the reason for that an dhow can I fix it?
Is the data type of the column (contains $0 values) MONEY? I export MONEY data to Currency (default mapping type) data in Excel with no problem. I'm using Excel2003+SQL2000
|||data type is float, not money. If I format excel column with 2 decimal I get 0.00 without any problem.
No comments:
Post a Comment