I can't manage to find a way how to format numbers like below:

Original Number: 65000
I want it formatted this way: 65,000

I tried various ways using the FormatNumber function but I can't get exactly what I want. I want to display a comma after the third number from the right. It must be a comma and not a point.

Can anyone please help me

Thanks You

Hello, Ivany!

I guess I know what is going on... I had exactly the same kind of problem sometime ago!! ;)

Have a look at http://p2p.wrox.com/topic.asp?TOPIC_ID=35390 !

Cheers,
fskilnik

;;;I want to display a comma after the third number from the right


   function alterNum(numVar)
      alterNum = replace(numVar,"000",",000")
   end function

   dim num
   num = "65000"
   response.write alterNum(num)

Wind is your friend
Matt

Hello Ivany and mat41,

I created another function, similar to mat41´s, but a bit more general. I hope you find it useful:

function USCurrency(currValue)
 USCurrency=FormatCurrency(FormatNumber((currValue) , 2, -2, -2, -2))
End function

When you have (say) the currValue= 76543,21 (21 is decimal) this function will get 76,543.21 (thousands and decimals separators)

Important: don´t forget to write "LCID = 1033" (for US formats) at the top of the page where this function is defined!

Cheers,
fskilnik