Regulate Date Text For Free

Click on the "Format" button and go to the "Protection" tab. Check the box for "Locked" to lock the cells. Click "OK" to close the "Format Cells" dialog box, and then click "OK" again in the "New Formatting Rule" dialog box.

To convert a date value to text without losing its formatting, follow the steps below: Select your date value. Go to the Home tab. Under the Number group, choose Text format from the drop-down.

Date/Time Formats With The Unicode Text Adapter yyyy-M-d ? Example: 2013-6-23. M/d/yyyy ? Example: 6/23/2013. d/M/yyyy ? Example: 23/6/2013. dd.MM.yyyy ? Example: 23.06.2013. dd/MM/yyyy ? Example: 23/06/2013. yyyy/M/d ? Example: 2013/6/23. yyyy-MM-dd ? Example: 2013-06-23. yyyyMMddTHH:mmzzz ? Example: 20130623T-0500.

In your Excel worksheet, format the dates exactly as you want the text strings to look like. Select all of the dates you want to convert and press Ctrl+C to copy them. Open Notepad or any other text editor, and paste the copied dates there. Notepad automatically converts the dates to the text format.

Select the cell or cells with serial numbers that you want to convert to dates. Locate the "Home" tab in the top right of the Excel window and click on it. Find the "Number Format" box in the toolbar that will usually say "General" or "Text." Click the down arrow next to the box and select "Date" from the menu.

Part 1 Using Text Function Select the cell containing the date you want to convert. ... In a new cell, use the formula "=TEXT(CellReference, "DesiredFormat")". Replace "CellReference" with the cell containing the date and "DesiredFormat" with the text format you want (e.g., "dd/mm/yyyy" or "mmm dd, yyyy").

Excel DATEVALUE function - change text to date The DATEVALUE function in Excel converts a date in the text format to a serial number that Excel recognizes as a date. So, the formula to convert a text value to date is as simple as =DATEVALUE(A1) , where A1 is a cell with a date stored as a text string.