Fomratting Numbers!

[bomayed]

How to format this number : 100343E21 to a normal number in ASP ?

Thank you

 

[foxbox]

mmmm, what is 'normal'?

n ="100343E21"
response.write FormatNumber( n , 0)

hth,
Foxbox

 

[shaddow]

You need to convert from Hexadecimal values to Decimal.

Function Hex2Dec(nr) 
   Dim n, i, digit, dec 
   dec = 0 
   n = Len(nr) 
   For i = 1 To n 
      dec = dec * 16 
      digit = Mid(nr, i, 1) 
      dec = dec + InStr("0123456789ABCDEF", digit) - 1 
   Next 
    Hex2Dec = dec
End Function

decval=hex2dec("100343E21")

________
George, M

 

[foxbox]

to me 100343E21 is not hexadecimal but 100343 times 10 power 21 (often called 'scientific notation'). So this represents this huge number:

100,343,000,000,000,000,000,000,000

("How many things can go wrong when you fly to Mars?&quot

hth,
Foxbox

 

[shaddow]

I think if you only use
FormatNumber("100343E21&quot it should do the job then


________
George, M

 

[foxbox]

yep, my

n = "100343E21"
response.write FormatNumber( n , 0)

is the same as
response.write FormatNumber( 100343E21 , 0)

is the same as
response.write FormatNumber( 100343E21 )

and with such a number it is crazy to want
response.write FormatNumber( 100343E21 , 6)











hth,
Foxbox

 

[shaddow]

Hehehe, I didnt see your Post before, but that was a surprise for me to see FormatNumber displaying Scientific numbers. Never tryed before this.


________
George, M