Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text box in userforms and international number format
Hello,
I have a text box in userforms where users enter a decimal number. This number is then kept on a sheet (let say in cell A1). If the user has their regional option set on French for instance (where the decimal point is a decimal comma), they enter 0,7 in the text box then we run into trouble when the workbook is returned to a user with regional option set for decimal point: - the userform text box display 0.7 as expected, but cell A1 displays 0,7 and is not recognised as a number. The rest of the sheet displays numbers with decimal points as normal. Can somebody help? thanks PS: Same thing happens if I use the controlSource of the textbox properties or if I write the value on closing the userform -- caroline |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how format date with TEXT() function for international usage? | Excel Worksheet Functions | |||
Format function with international numbers | Excel Programming | |||
International number separator | Excel Worksheet Functions | |||
International number separator | Excel Worksheet Functions | |||
International number format (Excel 2000) | Excel Programming |