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.
as far see it, can choose between , saving number text.
Comments
Post a Comment