I want to convert number in text form in excel how could i do it?
344168
Put number in double quotes. For example, "2.03" will be regarded as text by excel.\n\nOr select the cells you want the numbers to be text, then right click, select "Format Cells", select "Text".
811386
In Excel 97 (Must upgrade!) ... Format ... Cells ... Number ... Custom.\n\nSelect #.##0.00;-#.##0.00 and edit it to #.##0.00;(-#.##0.00) \n\nIt also saves your new format at the bottom of the list.
330924
Say you have in Cell A1 of "Sheet1" is -400...\nif you want it on Cell A1 of "Sheet2" as +ve number no matter A1 on Sheet1 will change to +ve or -ve, then put   =ABS(Sheet1!A1)\nif you want it on Cell A1 of "Sheet2" as +ve number only when A1 on sheet1 is -ve (reverse sign) then put =-Sheet1!A1\nif you want no formula as above 2, copy A1 on Sheet1, right click A1 on Sheet2 and choose paste special, check the subtract and click ok
785570
try substituting letters for numbers and vice versa
366293
Click on this link from Microsoft to download a converter:\nhttp://www.microsoft.com/downloads/details.aspx?FamilyID=B9E11E83-F51B-4977-B572-8C042DF802C1&displaylang=EN\n\nOf course, this all depends on you having Microsoft Office on your machine!
779217
There are built-in functions in a programming language to perform that task.For instance in C++ we have: cint("string value") for converting the string value into integer.And in Visual Basic we have the val() function to do the same thing.
991056
This can be done in MS Words using Fields:\n\nhttp://word.mvps.org/FAQs/Numbering/PageNumbering.htm\n\nbut I have never been able to do this in Excel. I have tried just about any character or word inside the brackets that I could come up with, but no luck. \n\nA couple of times when I thought I absolutely needed the numbering, I pasted my charts and data into a Word document.\n\nIt wasn't perfect, but with some tweaking it was at least presentable.
770189
Number will have to be the actual number it is working it out from..and it might not work as a long and definately not an integer.\n\nNumber as String\nOdd as Long (or Integer)\nEven as Long ( or Integer)\n\nIf Not (Number <1 or Number > 10) Then\nNumber = Number / 2\nIf InStr(Number, ".5") then\nOdd = Odd + 1\nElse\nEven = Even + 1\nEnd If\nEnd If\nMe.Print "Odd: " & Odd & " - " & "Even: " & Even
942420
It depends on what kind of numbers you want it to display. For example, say you want to check a cell (A1) and put a 90 if it's greater than or equal to 90, 80 if it's less than 90, then you'd do this:\n\n=IF(A1>=90,90,80)\n\nYou can imbed IF's inside as well. For example if you wanted to put 90 for values between 90 and 100, 80 for between 80 and 90, and so on to 60 for 60 or below, you'd do this:\n\n=IF(A1>=90,90,IF(A1>=80,80,IF(A1>=70,70,60)))\n\nYou can pretty much put any statement in an IF. I use the above a lot as a teacher. All the examples you saw, if you just replace the letters with what you want, it should work.\n\nHope that helps!
828527
Create a table in Excel with the first column containing the number and the second column containing the word related to the number.  Then use vlookup to read in the figure and output the word.\n\nFor example, assuming that you want to replace values from 1 to 5 with words, your lookup table is as follows (with a range name of figure_lookup:\n1One\n2Two\n3Three\n4Four\n5Five\n\nCell A1 contains the number 1, then your formula is =VLOOKUP(A1,figure_lookup,2)  where A1 is the value being looked up in the table called figure_lookup (could also use cell references such as B5:C9), using the 2nd column.\n\n\nAnother option:\nOr a much more elaborate way to do this is with Visual Basic.  Details are at:  http://www.ozgrid.com/VBA/ValueToWords.htm
1055911
To put the formulae into Excel,  make a cell and call it 'X'.  Do not put 'X' into the cell.  This cell will be where you place the value for x.  Ie, if x=2, then put 2 in the cell for 'X'.\n\nFirstly, I am not sure what the '+ 2E' means, I have interpreted it to mean 'x10^2', ie, 100, 10 squared.  If this is wrong, you will have to change the formulae accordingly.\n\nWe will assume the cell for 'X' is A1.\nThe first formula, y=234x+2E+06, is written, into a new cell:\n'=((234* A1) * 100) + 6'\nThe other is:\n'=((546 * A19) * 100000) +1'\n\nThe other answerers have helped out with how to find out which one grows faster.  Ie, y = mx + b.
416121
As others have said, you can enter it as text, but then you always have to enter the 0.  You can force Excel to place the 0.\n\nIn the "Format Cells" window, if you choose the "Custom" option, you can enter a variety of formats in the "Type" box.  If you always wanted a 0 to appear before the remainder of the numbers, you could enter "0" and then as many "#" signs as you expect the largest number to be.  If your largest number would be 5 digits, enter "0#####".  If you want the nubmer to have a decimal component, "0#####.###".  If you want to force the decimals to appear, "0##,###.000".  If you want the number to represent dollars, "$0##,###.00".
840094
You use the dollar notation '$' For example if you write\n\n=sum($M$126/A3)\n\nand you cut and paste it will always keep it M126 (but the A3 will change). If you just want the Row to stay the same the M$126 or if you just want the column to stay the same $M126.\n\nNote you can also cycle through these options with the 'F4' key (i.e. if you get your M126 by clicking on that cell while entering your formula).
606125
sort the data by cell phone number\n\ninset a column to the right of the number column.\n\nin the first cell, enter this formula:\n=if(a1=a2,1,0)\nwhere "a" refers to the column with the numbers.\n\nhighlight the cell with the formula.  copy it.\npaste is all the way down to the end of the column.\n\nhighlight the column with the formulas.  copy it.  go to the edit menu, choose paste special and choose values.\n\nsort data by the column with the 1s and 0s in it.  anything with a 1 is a duplicate.
490179
If Ed answer was not the one you liked, you may see the "Value" in Excel Help, f this is what you asked for,\nThis Value is reffered to the result of a cell function.\nMeans\nWhen you enter =4*5 in a cell this "=4*5" is the cell content, while the "20" that appears in the cell is the "Value" of this cell\n\nHope this is what you asked for..\n\nXLMan
839840
To make the PIN number show up as a wildcard string:\n\nSelect the desired cells (Column A) right click and select "Format Cells", Select the "Number" tab, and go to "Custom".\n\nIn the cell that now says "General" type:\n"****";;;@\nexactly as shown\n\nAs for the other part, I think your best idea is to use an additional column and use the LOOKUP function.  Don't forget that you can always hide the extra columns by right clicking and selecting "Hide"\n\nHope this helps!\n\nPS  If none of this works, or if you have additional questions, email me at ThuckingSplut@yahoo.com, RE: Yahoo Answers - Excel.  I'll do my best to help you out!
890652
In A1 type =20*2.3 \nin B1 type =40*3.6\nand in C1 type =A1+B1\n\nAlternatively, just type =(20*2.3)+(40*3.6) in C1\n\nDon't forget to format C1 for currency! Right click on that cell, select format, then the number tab, select currency the pound symbol and 2 decimal places