Connecting Tech Pros Worldwide Help | Site Map

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

Newbie
 
Join Date: Aug 2009
Posts: 1
#1: Aug 25 '09
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's Avatar
Moderator
 
Join Date: Jan 2007
Location: logan, utah
Posts: 2,690
#2: Sep 1 '09

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


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
Reply