left(input, at(".", input)-1) + strtran(substr(input, at(".", input)), "#", "0")
>Input="###,###,###.##"
>or
>Input="##,###.####"
>
>What is the best way to replace # Signs after . with 0 ??
>
>(Output="###,###,###.00"
>or
>Output="##,###.0000"
>
>
>TIA
--Todd Sherman
-Wake Up! Smell the Coffee!