SQL Server to EXCEL number format -


i'm trying export data sql server excel. have table has column type number format. column holds on 18 digits of number. excel converts last 2 digits of number "0" , (9,30102e+16) format.

http://www.ufuktukenmez.com/wp-content/uploads/2013/07/dddddd.png

i need export data excel same in sql format.

also need shown number in excel.

excel format: 9,30102e+16 , when clicked on number value 93010241000000000 sql format: 93010241000000011

excel (2010) supports precision of 15 digits only.

http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-hp010342495.aspx#bmcalculation

as far see it, can choose between , saving number text.


Comments