Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2013-03-13 : 13:24:49
|
| Hi all, this is SSIS 2008 R21. My package exports a currency data type to Excel.The excel column displays 3 (for 3.00) or 2.9 (if the amount is $2.90)I want both decimal places to show. When I change the font after exporting to excel, nothing changes.2. What does the "tick" mark at the top of the column mean?Thanks, Jack |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2013-03-13 : 19:52:09
|
| OK - I was able to resolve the formatting problem. I added a "hidden" line that has bogus cell values with the correct format. Kind of a messy workaround. It just seems that Microsoft would be able to make exporting SQL Server data to Excel (Their own product) easier. |
 |
|
|
|
|
|
Export to Excel - Format problem