I have had some numbers read into Excel from an external program. These numbers are currently formatted as text (column J). I would like to convert these numbers from text format to number format (decimal) as shown in column K as an example. I have already tried different possibilities (e.g. using the function "Text in Columns" and "Custom Formatting") but so far it has not worked. Can anyone help me?

CodePudding user response：

Another way - use Data | Text to columns. Accept the defaults and change the destination to column K:

Or click on the down arrow next to the error symbol and select Convert to Number to convert in-place.

CodePudding user response：

Use value function like this in the formula bar =value(jn) note: n is the row number in which your values are present