Put a textboxvalue formatted "#,##0" to a cell formed as value not text

I've made a userform that gets at value from a worksheet and at the sam time format it as #,##0. When transfering it back to the worksheet it's textstring but i want it to be a value. Please help
Bengt