Question Locked
Numeric data format
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.