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 |
|
PoojaJ
Starting Member
10 Posts |
 Posted - 2007-04-10 : 09:11:30
|
| HiIn the Exported Excel File the Format of a Field whose value is always 0 should be 0.00. I used the following code in Sql select Stmt:-Select convert(numeric(26,2), Convert(Varchar(5),0.00)) as [Column Name]. But still in the Excel sheet Value of this column appears as 0. Can any one suggest as to how do i go abt it??Thanx in advance. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-04-10 : 09:14:36
|
| You can use IMEX=2 when exporting.But this might not help you. We have no idea of how you export the data. You haven't told us.Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
Formatting in Export to Excel