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 |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2010-01-18 : 01:58:46
|
| Hi guys,I am having a report with field CUST_NUMBER (is of varchar datatype) with some values like this :012345345678536287096487063745Now when exported to excel, its showing on the top left of a cell a green triangle which indicates that the number is stored as text.Now the client here for some reason, wants the values to display as Number only i.e he doesnt want to see that green triangle.I tried in many ways, but when I am trying to convert the values to int, the values are displaying as follows:123453456785362879648763745i.e zeros are getting eliminated.So I want the values to display as they are with no green triangle showing beside the value when expoerted to excel.Any ideas???Thanks,Raaj. |
|
|
|
|
|
Problem when Exporting to excel.