Number stored as text
Hello,
I am entering Numeric data into a TextBox, and sometimes I have to
enter the data in European formatting (instead of a period (.) they use
a comma (,) as the decimal placeholder).
So when I change my Windows Region to (example) German, and I enter
10,02, it enters the spreadsheet as Text.
How do I get it to enter the speadsheet as a Number? The Windows
Region allows the spreadsheet to recognize the data as a number in
10,02 , it just doesn't do that automatically...
Suggestions!?
|