Question: How to convert a integer, formated as a text string, to integer?

Example: This formula replaces "." with a ",". The result is formated as a text string.

=(LEFT(I6,FIND(".",I6,1)-1)&","&RIGHT(I6,LEN(I6)-FIND(".",I6,1)))

Answer: By multiplying with 1 the result is formated correctly to numerical.

=1*(LEFT(I6,FIND(".",I6,1)-1)&","&RIGHT(I6,LEN(I6)-FIND(".",I6,1)))

A text string is automatically aligned to the left. A integer is automatically aligned to the right. Sometimes a integer is formated as a text string. Now you can identify wrong formated cells. (Take a look at the pictures again!)

Related posts:

Excel 2003: How to format numbers as text

Excel: Count the number of occurances an integer is in a list

Identify largest text value in a column using array formula in excel

Text to columns: Split words in a cell (excel array formula)

Search for a text string in an excel table