Thank u very much indeed..........
cdbl solved the problem and i now understand the difference between
val(10000) with format TextBox1.Value = Format(TextBox1.Value,
"#,##0.000")
appears as 10
and
CDbl(10000) with format TextBox1.Value = Format(TextBox1.Value,
"#,##0.000")
appears as 10,000.000
--
helmekki
------------------------------------------------------------------------
helmekki's Profile:
http://www.excelforum.com/member.php...fo&userid=6939
View this thread:
http://www.excelforum.com/showthread...hreadid=486844