Finding Decimal Places

[Brent Bortnick]

Does anyone know how to find out the number of decimal
places a number has. I need this info so that i can round
to 3 decimal places if the number has 3 decimal places or
to 2 decimal places if the number has 2 decimal places.

Any help would be great.

Regards,

Brent

 

[Evertjan.]

Brent Bortnick wrote on 02 jul 2003 in
microsoft.public.inetserver.asp.general:

Does anyone know how to find out the number of decimal
places a number has. I need this info so that i can round
to 3 decimal places if the number has 3 decimal places or
to 2 decimal places if the number has 2 decimal places.

If this is so there is no need to round,

or I do not understand what "having decimal places" means for a number.

 

[Evertjan.]

Andrew Paton wrote on 02 jul 2003 in
microsoft.public.inetserver.asp.general:

Try something like

<%
decimal = 0.001

pointposition = instr(decimal,".")
noplaces = len(decimal) - pointposition
%>

This should return (well it does i tested it) a value of 3. Or however
many decimal places there are in the variable "decimal"

This is where vbs InStrRev() is for

<%
decimal = 0.001
noplaces = len(decimal) - InStrRev(decimal,".")
%>

Beware, localized versions sometimes need InStrRev(decimal,",")

 

[Brent Bortnick]

Thanks That worked.

-----Original Message-----
Try something like

<%
decimal = 0.001

pointposition = instr(decimal,".")
noplaces = len(decimal) - pointposition
%>

This should return (well it does i tested it) a value of 3. Or however many
decimal places there are in the variable "decimal"






.