i have a textbox which i required it to be of either a currency or decimal value.

amtvalue = FormatNumber$(Val(amttb.text, 2)

had been using this formula to do the checking and converting and i realise tat i can't realli fully convert the string into a decimal.

example:
if value of amttb.text is "dsa.32", output for amtvalue will be 0.00

however, if amttb.text is "123.fsdf", output for amtvalue will be 123.00

is there another way for mi to do the check and make it such tat even if the input is "123.fsdf", the output will still be 0.00?