none
number format for field that has 15+ digit

    Question

  • hi,

    in a report that one field is a numeric value that has likely 16 digits,
    so if i exported report to csv and open in excel i see the results like 2,00904E+15

    how can i set a number format or doing something else for this issue

    thanks

    Wednesday, April 15, 2009 6:56 AM

Answers

  • Excel only supports 15 significant digits.  You may want to try casting the number to a decimal on the SSRS side and then wrapping that in a CSTR(), but you won't be able to ever work with it in Excel with more than 15 significant digits.

    -Sean
    Program Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs
    Wednesday, April 15, 2009 9:16 PM

All replies

  • hi

    Convert the field value to string using CSTR() function and export
    Chandra, http://www.ggktech.com
    Wednesday, April 15, 2009 1:06 PM
  • thanks for your reply

    i try but no effect, the field must start with " and must end with " like "2009045544786542"
    after export csv and open in notepad,

    so when i use CSTR() 2009045544786542 is not return to "2009045544786542", it remains no change

    any solutions?

    thanks

    Wednesday, April 15, 2009 3:22 PM
  • Excel only supports 15 significant digits.  You may want to try casting the number to a decimal on the SSRS side and then wrapping that in a CSTR(), but you won't be able to ever work with it in Excel with more than 15 significant digits.

    -Sean
    Program Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs
    Wednesday, April 15, 2009 9:16 PM