Select the cells youd like to convert to numbers and make sure their format is set to General.

How do i convert text to number format in excel vba. Click Kutools Content Convert between Text and Number. Convert text to Number with ZERO Digits and Number convert ZERO Digits Sub ZERO_DIGIT On Error Resume Next Dim rSelection As Range Set rSelection rSelection rSelectionSelect With Selection SelectionNumberFormat General Value Value End With rSelectionSelect SelectionNumberFormat 0 Set rSelection Nothing End Sub Convert text to Number with TWO Digits and Number convert. Those numbers will be formatted as text.

Right click at the cell which contains the date you want to convert to number and in the right-click menu select Format Cells common. To convert simple text values to numbers you can use the the VALUE function or simply add zero as described below. The Long Data type is the same as an integer.

Use the Format Cells option to convert number to text in Excel If you need to quickly change the number to string do it with the Format Cells option. In the window that opens make sure General is selected as the number format and select OK. Right click on them and pick the Format Cells option from the menu list.

As you know the first step of the function is the expression which is nothing but the number you want to format. The next step is Numdigitafterdecimal which is nothing but the number of digits you want to see after the decimal point which is 2 in our case. Then select any format.

Next select the cells where you want to convert the text into numbers. The result will be 123456789. This would instantly convert all the numbers stored as text back to numbers.

Now apply the format we wish to apply in this case format is date format ie. From the menu that appears select Convert to Number option. Select the range with numbers that you want to change to text.