Formating a string convertion

[mtheriault2000]

Hello

I want to convert a number in a string and have the result formated using 4 digits like

STR(1.4220) = " 1.422"

As result, I'm looking for "1.4220"

Martin

 

[shg]

=text(" 1.422", "0.0000")

 

[mtheriault2000]

Thanks