Making a textbox on a form to a number.

[Johncon17]

I have a textbox on a form that is always a number, but when this is transferred to a cell it is not read as a number, therefore I cannot do any calculations with it?

 

[abdelfattah]

Hi,
maybe option general in ribbon is text , not number try to make sure that.

 

[Johncon17]

Thanks but that does not work, as when it is transposed from a teaxt box it also changes the cell.

 

[abdelfattah]

Can you issue some pictures what try to do ?
it's difficult to guessing ,maybe I misunderstand you what you want!

 

[Johncon17]

In my form I have a textbox, this will only be used for numbers.
But when this is transposed to a cell it formats as text, and I do not want to keep going into the cell to change to a number (this would take ages).
Attached is the Form Textbox, and an image of that number in the cell.

 

[abdelfattah]

did you try this

check this
Excel: convert text to number with formula and other ways

 

[Skyybot]

CInt converts to Integer.

Option Explicit
Sub ConvertStringToInteger()
Dim str as String, int as Integer
str = "25"
int = CInt(str)
End Sub