I want to pad my numbers with leading zeros, for a total of three places. For example, I want:

"18" to be "018"
"118" to be "118"

What is the best way to do this in ASP?

Thank you in advance!

WebGrrl

Well, I never did asp, but a quicke google search gaved me that:
http://lists.evolt.org/archive/Week-...12/120001.html

<tip author="Anthony Baratta" subject="Padding Numbers with leading Zeros
in ASP">

I used to run numbers I wanted to pad through a function that checked to
see if the number was less than 9 or 99, and padded with leading zeros
accordingly. The other day I stumbled across a more simple and straight
forward way. (Believe it or not it was at the Microsoft MSDN site.)

_Padding with a Leading Zero the Day and Month_

strDay = Right("00" & CStr(Day(Now())),2)
strMonth = Right("00" & CStr(Month(Now())),2)

If you want two leading zeros for hundreds just change the 2 to a 3.

Piece of pie.

</tip>
--
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

Thank you , I think that will do the trick!

WebGrrl

In ASP Classic, you can use the Format function, like you would in Excel:

Format(18, "00000.0")

Arguments might be reversed - I haven't done this for a while.

Hi,

Not sure format will do this, but here is what I have used.

NumberOfLeadingZeros = 3
MyNumber = 18

MyNumberWithLeadingZeros = right(string(NumberOfLeadingZeros,"0") & cstr(MyNumber),NumberOfLeadingZeros)

response.write MyNumberWithLeadingZeros

bbuttons way will work the best. There are otherways of handeling the problem, but you should be checking your string and formatting it anyways, so best to handle the problem before inserting.