Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a text number converted to numeric & it has a formula in it
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a text number converted to numeric & it has a formula in it
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/ex...346511033.aspx HTH, JP On Oct 23, 10:43*am, Bud wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date converted to Text Number | Excel Discussion (Misc queries) | |||
Stripping text before a number (alpha or numeric) | Excel Worksheet Functions | |||
how can I convert numeric number into text | Excel Discussion (Misc queries) | |||
Convert numeric part of text to number | Excel Programming | |||
Database text converted to numeric | Excel Discussion (Misc queries) |