Hello

I have a formula that is just taking a field from one worksheet and placing
it to another worksheet in column B. I have random numbers of rows each time
but have a counter.

I than compare that field in column B to personnel numbers in another
worksheet obtaining the name fo the person.

The issue is that the numbers in column B are represented as text so it
isn't matching.

How can I get the fields which now contain a formula and the number to be
represented as numeric so it will match.