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 |
|
peace
Constraint Violating Yak Guru
420 Posts |
 Posted - 2012-04-23 : 04:38:19
|
| how can i solve this?i send the query result to email in csv format.But for the number which is this '447507435689', when appear in excel it will be this '4.47507E+11' |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-04-23 : 07:33:20
|
| This is one of those "helpful" things that Excel does for you. The recipient can format the cells to Number (or Text) instead of General. You cannot control it, because it is the recipient's Excel installation that does that formatting. They can, of course, open it in notepad or TextPad and see the unformatted number. |
 |
|
|
|
|
|
Number in excel