Format to Danish charaterset
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. |
Format to Danish charaterset
You can use replace() to change the commas to periods. Let the user type in
the Danish format of periods and then have the macro use replace to make them commas so excel except that values. "Danish Excel user" wrote: 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. |
All times are GMT +1. The time now is 10:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com