Need a text number converted to numeric & it has a formula in it

[Bud]

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.

 

[JP]

If I understand you correctly, you want to convert a number stored as
text, to a number.

One way is:

1- Find a blank cell and type the number "1" in it.
2- Copy it, then select the cells that contain numbers stored as text.
3- Right-click and choose "Paste Special", choose "Multiply"
4- The text-stored numbers should be converted to "real" numbers.

And here's another way:

http://office.microsoft.com/en-us/excel/HA010346511033.aspx

HTH,
JP