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 |
|
sahar_sultana
Starting Member
2 Posts |
 Posted - 2009-05-13 : 19:32:55
|
| Hi, I created the following table and defined this table in DTS-Transform-Data-Task-Properties to import file into Excel file.A_Cost, B_Cost and C.Cost but when I get result into Excel then A_Cost, B_Cost and C.Cost shows General type value i.e.23.40, 23, 145.2 where as I need results like 23.40, 23.00, 145.20. Results with two decimal places.Please help why I am not getting result un excel with two decimal places. Please help. Thanks.CREATE TABLE `Payroll_Audit1` (`Empid` VarChar (10) , `Startdate` DateTime , `A_Cost` DECIMAL(6,2) , `B_Cost` DECIMAL(6,2) , `C_Cost` DECIMAL(6,2) )--Getting Results23.40, 23, 145.2--Desired Results23.40, 23.00, 145.20 --with two decila places. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-05-13 : 19:40:33
|
just format it as 2 decimal place in Excel (Format - Cell)
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
sahar_sultana
Starting Member
2 Posts |
Posted - 2009-05-13 : 21:58:48
|
| HI,I did but when I execute the DTS then format is changed in genral format with no decimal places in xls file. Any other idea. |
|
|
|
|
|
|
|
|
Not getting two decimal places after run the DTS