How can I display large real numeric value in excel (no exponent)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ashoopapa
    New Member
    • Aug 2009
    • 1

    How can I display large real numeric value in excel (no exponent)

    Vb ASP: Whenever I export a large numeric value into excel. Excel displays/formats it as exponential:
    Exp: 1615015075295 is shown as 1.61502E+12

    Note: I need to show the real value.

    help
    Thanks
  • jhardman
    Recognized Expert Specialist
    • Jan 2007
    • 3405

    #2
    There are ways to affect formatting, but the exponential is default, and I know I have never tried to change from the default. Would it be a problem if you formatted it as text? It would display right, but you couldn't run calculations off of it.

    Jared

    Comment

    Working...