I have a string x123456. I use the right function to remove the x
=Right("x123456",6)
Then I'm trying to convert that to a number, but no matter what I use, CInt, CLng, CDbl, I get an overflow error.
What am I doing wrong? Is there an easier way to separate the number from the letter?
Thanks!