View Full Version : thousand separator
11-19-2003, 07:34 AM
im looking to change a number into a number with thousand separators eg.
48243832 into 48,243,832
is there any way of doing this? i thought thats waht groupdigit in formatnumber was but, it didnt seem to make any difference
11-19-2003, 07:58 AM
FormatCurrency(Expression, NumDigitsAfterDecimal, IncludeLeadingDigit, UseParensForNegativeNumbers, GroupDigit)
<% =FormatCurrency(31567) %>
11-19-2003, 04:02 PM
and if i dont want a currency, just a separated number?
11-19-2003, 05:37 PM
Maybe <% FormatNumber (31567) %> would work. I haven't used that myself. I had to look it up. :)
Edit, sorry. I just read the bottom part of your post. :(
11-19-2003, 06:47 PM
i thought thats waht groupdigit in formatnumber was but, it didnt seem to make any difference
That's exactly what it's for, have you checked the Control Panel to make sure it's set up (Look under the "Regional Settings" applet). What value did you use for the GroupDigits parameter?
11-22-2003, 02:14 PM
well it didnt make any diference and its set up rite in windows
11-23-2003, 04:44 PM
Since you want a plain number and not an amount of money, you need FormatNumber, not FormatCurrency:
FormatNumber(Expression [,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]])
If it doesn't work for you then your regional settings (on the *webserver*) are NOT configured correctly.
11-24-2003, 07:28 PM
ah hah! it took me ages to work out the syntax for it (those s didnt help)
i just needed like
11-24-2003, 08:44 PM
Originally posted by ghell
ah hah! it took me ages to work out the syntax for it (those s didnt help)Why? It's fully documented in your VBScript documentation (http://www.microsoft.com/downloads/details.aspx?FamilyId=01592C48-207D-4BE1-8A76-1C4099D7BBB9&displaylang=en)! :p
And the square brackets indicate optional arguments. ;)
11-30-2003, 04:25 PM
dont patronise me ¬_¬
thanks for docs link.. i didnt actualy know there was any VB script documentation, and i knew s were optional but when im trying to work out how it works it just makes me wonder if i need any of them, so i try it... like if it says function([option1],[option2],[date]).... i know that you can use data without calling the server date by putting brakets around it, so it can be confusing with bools etc.... shutup.. i know im stupid.. but...arses to you :thumbsup: