Extracting a number from a string

I am trying separate the first number in a cell with the data type of 345/937/987 so I can compare sums of following rows to that number. How can I single out that number and use as a variable in code?

Here is one way:

Please Login or Register  to view this content.

Thanks, I'll do some testing

That helps,Thanks. Now I want to replace the first number's color to red. Is it possible to do without the whole cell being red?