Whole number to decimal problem

[bob123bobcom]

I am pulling a data field like 1704370 but i need it to be like 1.704370. Any help to do this in my vbscript/asp page.

 

[pgk]

Hi,
Try the following VB Script:

msgbox(FormatNumber(1704370,Len(1704370)-1))

Check out the FormatNumber function for more options. Hope it helps. Let me know what happens.
With regards,
PGK

 

[MichaelRed]

Hmmmmmm,

Not familiar w/ the function (method). Help list it as an XML function, not vb?

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[pgk]

Hi MichaelRed,
It is a VB Script function. Hope it helps. Let me know what happens.
With regards,
PGK

 

[CCLINT]

??? [/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[Oak]

If you're working with values, then you should use:

1704370 = 1.704370 * (10^6)
1.704370 = 1704370 / (10^6)
so,
result = number / (10^exp)

lngNumber = Val(txt.Text)
strNumber = Str$(lngNumber)
intExp = Len(strNumber) - 2
dblNumber = lngNumber / (10 ^ intExp)
lbl.Caption = dblNumber

Oak