Question

 How do I convert an excel date to text?

Answer You can use this formula (date in B2):=TEXT(B2,"dd-mmm-yy")
http://answers.yahoo.com//question/index?qid=20070608015737AAFRXJh

Top Q&A For: How do I convert an excel date to text

How To Convert Text in Word to Excel?

Although Word and Excel work hand-in-hand when you're creating a mail merge or embedding a chart, each performs a different function. Word is a word processor, while Excel is a spreadsheet. At time... Read More »
http://www.ehow.com/how_6402895_convert-text-word-excel.html

How do I convert text in Word to Excel?

Press the "Control", "Shift" and "*" keys to turn on paragraph marks. Divide the text lines into Excel rows by going to the end of each line and pressing the "Enter" key. Divide the text within eac... Read More »
http://www.answerbag.com/q_view/2125085

How do I convert date format in Excel?

Select Format CellsOn the "Home" tab, select "Format." From the "Format" menu, select "Format Cells" from the bottom of the menu list.Click OKOn the "Number" tab, select "Date." From the "Type" men... Read More »
http://www.answerbag.com/q_view/2092000

How do I convert numbers to text in Microsoft Excel?

Launch Microsoft ExcelPosition your mouse pointer over the Windows "Start" button. Click the left mouse button once to bring up the Start menu. Click "All Programs." Position the mouse pointer over... Read More »
http://www.answerbag.com/q_view/2119720


feedback
loading