TextBox????

[BobT]

Sending data to "accounting"formatted column in a
spreadsheet froma form,appears to enter as text(no
formatting whatsoever). This is a new textbox added to an
old form.
I've reloaded Excel 2000.
Thanks for any help.

 

[Dave Peterson]

Any chance you're not sending real numbers to that cell?

If your data is in C12, if you put =isnumber(c12) in another cell, what do you
get?

if it's not a number, then the numberformat won't do anything.

If this is true, maybe you can clean up the value in the textbox.

worksheets("sheet1").range("C12").value = cdbl(textbox1.value)

(with some more validation!)