Problems with cell-binded textbox

[don H. Lee]

Hi newsgroup

I already posted this on the german newsgroup but I didn't get the needed
answers so I try again in english.

I have the following problem:

I am using Excel 2000, WinXp, Swiss-German settings
I have a form where a textbox is placed. This textbox has a controlsource to
a cell ("Mysheet:h3"). The Format of the cell "h3" is general (don't think
that this really matter).

No I start the form an try to put "18.5" into the textbox. When exit the
value changes to 399... I changed the format of the cell and put it to
number but didn't work.

How can I handle this?

Any ideas?

Thanks alot and best regards

D.H. Lee

 

[dan dungan]

Hi D.H. Lee

Try changing the format of the textbox in properties.

Dan