values in number format but actualy not

mohammad10  wrote:  ``how can i remove trailing space``

It is not a trailing space per se.  But we can use LEFT(R7,7) to ignore the last character.

To convert the data, use =VALUE(LEFT(R7,7)).  More generally, =VALUE(LEFT(R7,LEN(R7)-1)).

The last character seems to be the Unicode character 8236 (U+8236).  You can see this in Excel with =UNICODE(RIGHT(R7,1)).

If your version of Excel does not support UNICODE (mine does not), in VBA, we write AscW(Right([R7],1)).