How can I convert a num in words with MS-EXCEL?
596850
Do these words have only numbers? or do they have extra letters?\nIf the numbers you need to convert are in the beggining of the cell, use the Value function\n=value(A1)\nassuming that the cell you want to convert is in A1\n\notherwise\nsend me you e-mail address , and I will be happy to help\n\nI am the XLMan
790619
you can use the normal calculator of windows for these conversions.\n\nOptions are only available in a scientific view of the calculator.
808987
lets say we have text1 as the meter textbox and text2 as the centimeter textbox as the simplest conversion example:\nsub text1 change\ntext2.text = str(val(text1) * 100)\nend sub\nso when you type a value in the meter box, it will multiply it by 100 and show the result in the centimeter box.
348716
Can't do that in Excel. The best thing you can do is type your headings in row 1 in each column.
1111499
If the source number is in cell A1, just type =-A1 in a blank target cell.\n\nAssuming that your mis-entered numbers are all in a column, you can then drag the formula down the target column to replicate.\n\nFinally, if you want to get back to real values instead of fomulas, you can select the target column with the switched numbers and copy it. Then >Edit>Paste Special>Values .
1158354
This does not require hiring a professional, it's a rather simple & straightforward program. \n\nRaven put you on the right track, use the modulo (%) operator to break out the thousands from the hundreds, the hundreds from the tens, etc.  Define an array or map of strings with the words for each number up to twenty, then thirty, forty, fifty.. to ninety, then hundred, thousand.  Break the number apart, and get the appropriate words from the array & string them together.
497310
After draggin the file into Excel, your database will take only one column.\nSelect that column and go to Data > Text to columns to start the wizard you need to convert it.\n\nXLMan
1104463
yes sort\nyou have to highlight it and\nin excel \nData --> Sort --> Assending order\n\nin word\nTable --> Sort
102604
I am assuming that you are using Excel.  Highlight your cells and click Format->Cells on menu bar.  Change from text to Number.
586461
I thought the istext formula would work but they don't.\nHere's another way to solve this issue. Assume the cell to test is in A1, enter the following formula in another cell:\n\n=IF(ISERROR(LEFT(A1,1)/1) ,"yes","no")
230306
What hurricane is describing is using a string qualifier.\n\nFor example (in this example, replace the . with a tab):\n\n'Text column 1'. '04323221'. 'Hello'\n'Blah blah blah'. '34332321'. 'Paris'\n'Random ol&#92;' text'. '9223221'. 'Green'\n\nNotice that each field begins and ends with a single-quote. The idea is that by qualifying each field with single-quotes, Excel will import the contents as a string.\n\nThat sounds great on paper and should work in theory, but it won't, because anytime Excel sees all digits, it wants a number, even if you use qualifiers.\n\nYou have to manually set up the import in Excel to work properly, if you want those zeros saved.\n\nTo do that:\n\n1. Open Excel\n2. Use File --> Open to open your TSV file\n3. Set the Files of type drop-down to be All Files, navigate to where your TSV is saved, and open it.\n4. In the dialog box, choose Delimeted, skip any rows that need skipping, choose the right encoding and click Next\n5. Make sure Tab is chosen in the delimeters and, if you have opted to use a text qualifier, it is selected.\n6. Click Next\n7. For columns that will contain leading zeros, click on that column, then choose text for the Column data format from the radio buttons at top right.\n8. Click Finish.
130036
1. Start Microsoft Excel\n\n2. Before you type fractions in cells, preformat the group of cells that need to be displayed as fractions. Select the cells where you want to enter fractions, and then select Cells from the Format menu.\n\n3. Click Fraction in the Category list, and then, from the list on the right, select the type of fraction that you would like to display. Click OK.\n\n4. Now you are ready to type fractions in these preformatted cells. To type fractions in cells, just type the numerator, followed by a slash (/), then followed by the denominator—do not type spaces.\n\na. For example, 1/2 would represent one-half, as would 4/8 (Excel reduces fractions to their lowest terms). If you need to type a whole number and a fraction in one cell, type the whole number followed by a space, and then type the fraction (numerator, slash, denominator).
860421
you need to filter on the bound column, which is the first column, which is numeric.  \n\nAnnual=4\n\nFilter in 4\n\nhope this helps..
1165079
Create a user-defined function: (make sure to paste this in a module for the workbook, not in a sheet)\n\nFunction CountChars(Txt As String, Char As String) As Integer\n    CountChars = Len(Txt) - Len(Replace(Txt, Char, ""))\nEnd Function\n\nThen use the new function:\n=countchars(lower(A1),"a")&" "&countchars(lower(A1),"e")&" "&countchars(lower(A1),"i")&" "&countchars(lower(A1),"o")&" "&countchars(lower(A1),"u")\n\nAs written, it will return an answer of 1 2 0 0 0 for the string "statement." One "a", two "e" and 0 for the other three vowels.\n\nYou should be able to come up with a better formula to use it.
135188
1. Open Microsoft Word \n2. Click "Table". \n3. Click "Formula". \n4. In the formula box, type the following: \n=X97:S1587 \n5. Change the number format to 0.00%. \n6. Change the paste function to SUM. \n7. Press OK. \n8. "!Syntax Error, :" will appear. \n9. Highlight "!Syntax Error, :". \n10. Go format, font and change the color to \nGray-25% \n11. Click OK. \n12. Highlight "!Syntax Error, :". \n13. Go format, font and change the font effects to Double strikethrough and Embossed. \n14. Press OK. \n15. Go to the line beneath "!Syntax Error, :", and type "MotoMad" in Rockwell, size 29. \n16. Press Enter twice. \n17. Press File, Save As, and save it as "MotoMad". Then press "Options". \n18. Change "Save Word Files As", to "Rich Text Format". \n19. Click OK and Save the file in any folder. \n20. Close Word and open the file from the folder you saved it to. \n21. This should open Motocross Madness V.1.1. \n22. Use the arrow keys to steer the bike and space for extra turbo\n\nHave fun!!!
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
976225
Go in the Data menu, then select Validation.\n\nYou can select "List" in the drop-down menu and enter either a cell range or custom values in this format: "A;B;C" (without the quotes)\n\nGood luck!