Truncate string with decimal point

[Penrodcigar]

Anybody have a simple way to truncate a string number with a decimal so it limits the places after the decimal?

 

[PHV]

Something like this ?
Format(Val(yourNumericString), "0.00")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Penrodcigar]

When I try your expression

Format(Val(yourNumericString), "0.00")

I get a Compile Error: Sytax error message

For "yourNumericString" I insert a variable for the string say TVar = "23.23567" so...Format(Val(TVar), "0.00")...is my expression

Not sure what to put for "Val"

and I presume "Format" is a CMD function

 

[randy700]

Public Function Tvar()
    Dim tvar As Double
    tvar = 23.23567
    tvar = Format(Val(tvar), "0.00")
    Debug.Print tvar
End Function

returns 23.24
What have you done differently?


Randy

 

[SkipVought]

Val function converts your number STRING to a NUMERIC VALUE.

Skip,
[sub]
[red][/red]
[/sub]

 

[SkipVought]

...and

the Format function returns a STRING, which can, in turn, be converted to a NUMERIC VALUE.


Skip,
[sub]
[red][/red]
[/sub]

 

[Penrodcigar]

That's great. Working fine now. Thank you....anybody have a convenient way to display decimals as fractions?

Regards,
Peter Landeck