sijpie
Well-known Member
- Joined
- Nov 1, 2008
- Messages
- 4,269
- Office Version
- 365
- Platform
- Windows
- MacOS
Just in case anybody runs into a similar issue.
I have developed a workbook with a large userform for data editing. Some of the users noticed that in some fields they could not enter more than 3 digits. In those fields I have a textbox_change macro running that prevents entering of decimals.
Another thing they noticed was that messages or labels containing a number such as 120,000 would truncate after 120.
As I developed with regional settings English UK, and these users had regional settings Romania, I thought it may have something to do with the difference in thousands- and decimalseparators.
Changing the regional settings made no difference, but then I noticed in File/Options/Advanced that under 'Use system separators, even though it was ticked and should ignore what was in the boxes, the separators in the boxes where both '.'
Changing one of them to a comma resolved the issue.
I have developed a workbook with a large userform for data editing. Some of the users noticed that in some fields they could not enter more than 3 digits. In those fields I have a textbox_change macro running that prevents entering of decimals.
Another thing they noticed was that messages or labels containing a number such as 120,000 would truncate after 120.
As I developed with regional settings English UK, and these users had regional settings Romania, I thought it may have something to do with the difference in thousands- and decimalseparators.
Changing the regional settings made no difference, but then I noticed in File/Options/Advanced that under 'Use system separators, even though it was ticked and should ignore what was in the boxes, the separators in the boxes where both '.'
Changing one of them to a comma resolved the issue.
