Hi,

I am using a form to enter data to Excel 2007.

Private Sub nr5_Change()
Dim nr5 As Variant
nr5 = Format("#,##0.00")
End Sub

The standard format does not allow for localization which means that a user
has to type , between digits and not . as we use in Denmark.

Please advice.

Thank you.