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!)