Convert negative numbers with the sign on the right

I've previously explained how to convert text data into their numerical values. Now I'll show how to convert negative numbers (as text) and with the negative sign (-) to the right of the number. This might be useful especially when importing data from some accounting programs.

For example, suppose you find the text value 100- in cell D2. To convert that value to a negative number, enter this formula in a blank cell: =LEFT(D2;LEN(D2)-1)*-1.

*Note that you might have to replace the ; by , in the formula depending of your location.