>Input="###,###,###.##"
>or
>Input="##,###.####"
>
>What is the best way to replace # Signs after . with 0 ??
>
>(Output="###,###,###.00"
>or
>Output="##,###.0000"
>
>
>TIA
I don't know about the best, but try
lcStr = "###,###,###.##"
? LEFT(lcStr,RAT(".", lcStr)) + REPLICATE("0", Len(lcStr) - RAT(".", lcStr))