Exporting Numbers to Excel have wrong format

[Sweigs]

I am exporting numbers with 4 deciaml places, the last two being zeros. IE - 500.2300. When it is exported to excel it ends up as 500.235879 (or something like that). The problem I am having is if you sum the data in the SQL data base it will balance to zero. If you sum the data on the spread sheet it is never zero. I tried formating the column which does then display with two decimals but I believe it is not rounding the number but truncating the number which is causing the out of balance situation.

 

[MarkSweetland]

What data type is the column in the SQL table, real? float?


Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[tb]

Hi,

I have 2 questions ...

How are you exporting to excel?
How are you formatting the columns?



I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[Sweigs]

I am not sure how to modify my orginal request but I have discovered that if I use a data type of double my export to excel works correctly. Thanks for everyone's reply.

John S