Formatting Output

[mdr2271]

Is it possible to format output as X,XXX and also as a percentage?

 

[emozley]

Do you mean take a number of any length and put commas in the right place or just numbers that are 4 digits long.

Also what would it be a percentage of?

If you had a value a and you wanted to show it as a percentage of b you would do:

<%

Response.Write(FormatNumber((a/b*100),1))

%>

This would write it to one decimal place.

 

[Sheco]

Try this format mask: #,##0%

 

[DotNetGnat]

try using...

formatpercent() function...

-DNG

 

[Sheco]

Bleh, ignore me, I thought I was in the forum for SQL Server Reporting Solutions

 

[Bullschmidt]

And for more on FormatNumber() and other VBScript functions:

Visual Basic Scripting Edition Functions

http://msdn.microsoft.com/library/d...html/adaabd2b-250e-4040-9eaa-127f5a41f8b9.asp

Best regards,
-Paul

http://www.Bullschmidt.com

- Freelance Web and Database Developer

http://www.Bullschmidt.com/DevTip.asp

- Classic ASP Design Tips