CODEWITHSUNDEEP
excel
TRUESIM
TRUESIM

Reputation: 69

Excel: Text to number

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?

enter image description here

Upvotes: 0

Views: 539

Answers (3)

Jeb_
Jeb_

Reputation: 21

Had same problem.

=VALUE(J1) or =VALUE(J1)*1 could help

also =CONCAT("0";J1) and then remove 0 (lil complicated, but worked)

Upvotes: 0

Tom Sharpe
Tom Sharpe

Reputation: 34210

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

enter image description here

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

enter image description here

Upvotes: 2

Kolli Sai Babu Chowdary
Kolli Sai Babu Chowdary

Reputation: 55

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

Upvotes: 0

Related Questions