Question about Business & Productivity Software
Please explain the proceedure to change from date format to text formet in microsoft excel work sheet.
Rama Mohan Komaravolu
Just use comment at the beginning of cell to change the date format to text.
Posted on Feb 27, 2013
Block off the cells (or row or column) in question, right-click and choose FORMAT CELLS. In the NUMBER tab, choose TEXT. This will make your dates appear exactly as they are typed, and not allow Excel to reformat them.
Posted on Nov 19, 2007
Tips for a great answer:
Jun 06, 2010 | Microsoft Excel for PC
Jun 26, 2009 | Microsoft Excel for PC
Apr 22, 2009 | Microsoft Excel 2003 (06503995)
Nov 21, 2008 | Microsoft Excel for PC
Apr 25, 2008 | Microsoft Office Professional 2007 Full...
Mar 20, 2008 | Business & Productivity Software
Oct 21, 2016 | The Business & Productivity Software
144 people viewed this question
Usually answered in minutes!