extract number format

[clozed75]

Hi,
I would like to know if there is a simple way to assign the number format of a variable to another variable.

e.g. I have "a" = "0.30" I want "b" be formatted with two decimals as "a"..

something like b = format(b, "0.00") BUT how can I get the string "0.00" out of a ?

thanks!

 

[clozed75]

i've done this way ..
For i = 1 To Len(a)
If (Mid(a, i, 1) <> "." And Mid(a, i, 1) <> "0") Then b = Replace(a, Mid(a, i, 1), "0")
Next

I wonder if there's any other way...