Solved: Format numbers

[ioncila]

Hi
I need a little help for a little issue:

In a textbox or combobox
if I write 1, it would appear 0,01
if I write 12, it would appear 0,12
if I write 12345, it would appear 123,45
if I write 1234500, it woulf appear 12.345,00
etc.

Is that simple?

Thanks

[mikerickson]

Perhaps something like
[VBA]Private Sub TextBox1_AfterUpdate()
With TextBox1
If IsNumeric(.Text) And InStr(.Text, ".") = 0 Then
.Text = Format(Val(.Text) / 100, "#,##0.00")
End If
End With
End Sub[/VBA]

[ioncila]

Thank You Very Much
Its solved