Right/Left Formulas and dropping leading zeros from result

[Eb0la11]

I am using the =RIGHT('Q-Tools Data'!A2,4) function on this data: 4004050.0001
and the result is 0001

How do I get the result to be 1 instead and drop leading zeros?

 

[Fluff]

Try
=--RIGHT('Q-Tools Data'!A2,4)
This will convert it to a number, thereby removing the leading 0s

 

[Eb0la11]

This worked. Thank you for the help.

 

[Fluff]

You're welcome & thanks for the feedback