I am using userform to enter data in a Worksheet.
I would like to know how can I enter a numeric data like “123456.12345”.
I tried with tCost = Format(mCost, “#,##0.00000”) but when the data is passed to the Worksheet it appears as “12345612345.00000”.
If somebody can help me, I will appretiate.