Assuming Q00003 is in cell A1 then:
=VALUE(MID(A1,2,255))
will return the numerical number 3.

Hope this helps
Rowan

wrote:
I'm comparing numbers between two cells and I used the conditional
format to do this. But now I need to remove a character from the first
cell in order to get the right results. The first
cell would have something like this Q000003 which would be the quantity
and the second cell would be 2. And my condition is if first cell is
greater than second cell than the first cell would change colors. But I
need to ignore the Q in order to get the right results. How do I fix
this?