how can i convert figure value into words in ms excel?
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
28735
Another way to approach this problem, which might be more convenient, is to do the following:\n1. Select the area of the Excel spreadsheet and "copy" it.\n2. Open the "Windows Paint" and "Paste".\n3. Then you can save it as a image file in a format of your choice.\n\n(You can follow a similar path with Word file, and choosing "Paste Special" instead of plain "Paste).
837908
click here:http://en.wikipedia.org/wiki/Microsoft_Excel
100785
You will need to write a program that acts as a screen scraper to pull the data you want. This will be hard if you are not a programmer.\n\nPossibly creating a link in your excell to get a spreadsheet of data for a stock would help you???\n\nhere is how to do it:\nPut each of these items into cells A6 through A20\nThis will allow you to change each item which are the stock symbol (lrw in this case) start and end dates.\nhttp:/ /ichart.finance. yahoo.com /table.csv?s=   (remove the spaces I did them so it could be read)\nlrw\n&a=\n0\n&b=\n1\n&c=\n1982\n&d=\n1\n&e=\n21\n&f=\n2006\n&g=d&ignore=.csv\n\nin cell A4 put:\n=CONCATENATE(A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20)\n\nand in cell A3 put"\n=hyperlink(A4,"Get Spreadsheet of historical data") \n\nnow click on the link and watch the chart load into a new spreadsheet.\n\nI know its not quite what you asked for but now you can graph and analyze the data for your favorite stocks.\n\nhttp://ichart.finance.yahoo.com/table.csv?s=bzh&a=0&b=1&c=1982&d=1&e=21&f=2006&g=d&ignore=.csv
461876
Use Word's integrated equation editor:\n\nInsert > Object > Microsoft Equation 3.0\n\nThis will launch an equation editor that will allow you to put in almost any mathematical symbol/number, etc.\n\nHope this helps.
792191
If you really want them to be numbers, then change the format of the cells. Use the number format "0000#" (or however many zeros you want).\n\nHowever, VLookup will not match the leading zeros in this case because the internal format of the numbers will be mathematical not textual. If you want to store the numbers as text (for instance, if they are ID numbers) then preface them with ' when you enter them. This tells Excel not to evaluate the cell.
1059671
http://www.google.com.eg/search?hl=en&q=convert+mdi+to+MS+word&meta=
511921
You  will have to reformat all the cells you need to be exported. Excel will not automatically append the double quotes.\n\nUse the following formula\n=""""&A1&""""\nAssuming A1 has 999, the formula will return "999"\n\nThen you can save the worksheet as a text file.\n\nYou can then copy, paste special, values over the original column or to another worksheet.\n\nNote: The formula needs four double quotes before and after the ampersand
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).
414373
Go to Office Depot and buy "Word Processing\nfor Dummies".  Easy answer.
879236
First, I don't think you should be using Excel. Excel is a spreadsheet program that is designed to work as one.  It is not meant to work with large amounts of text.  Excel will only allow 255 characters into a cell, regardless of how large it is.  Even if you manage to cut and paste into the cell, it will automatically trunkate at the 256th character.  If you are putting multiple paragraphs into each cell, I ask you why?  If you are going for the look, you can use Word and make a table.  The characters are unlimited in a Word table, so your formatting should come right it, without trunkating your hard work.  \n\nIf you must use Excel, the key to getting a forced (ie paragraph seperation) you should press and hold the Alt key while pressing the Enter key.  This will force a line break into the cell.  You should also change the wrapping of your cells by highlighting the cells and choosing Format, Cells, and on the Alignment tab- check the Wrapping box.\n\nI highly recommend using Word in a table format.  You can make it look exactly like an Excel printout, but will not run into the problems of the character limit.
1104463
yes sort\nyou have to highlight it and\nin excel \nData --> Sort --> Assending order\n\nin word\nTable --> Sort
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".
340972
Follow the steps below\n\n1. On the Insert menu, click Object, and then click the Create New tab. \n\n2. In the Object type box, click Microsoft Graph Chart, and then click OK. \n\n3. Graph displays a chart and its associated sample data in a table called a datasheet.\n\n4. To replace the sample data, click a cell on the datasheet, and then type the new text or numbers. If needed, you can import data from a text file, a Lotus 1-2-3 file, or a Microsoft Excel worksheet. You can also copy data from another program. \n\n5. To return to Microsoft Word, click the Word document.
180216
Have you tried xsl???\nhere's an example of how to do it:\nhttp://www.w3schools.com/xsl/xsl_transformation.asp
880439
In MS Word, load that file, than "Save As..." and select MS DOS Text. \n\nEasy enough, right?
115616
1. Open Microsoft Word\n2. Right Click on Toolbar\n3. Select CUSTOMIZE\n4. Select COMMANDS tab.\n5. Select FORMAT from left Column\n6. Drag SuperScript from Right Colum and drop it to Toolbar\n7. Drag SubScript from Right Column and drop it to Toolbar