View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Justin[_14_] Justin[_14_] is offline
external usenet poster
 
Posts: 17
Default 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!?