Numeric data format

By smarta ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums