Feature Date Text For Free

Your answer First, pick the cells that contain dates, then right-click and select Format Cells. Select Custom in the Number Tab, then type 'dd-mmm-yyyy' in the Type text box, then click okay. It will format the dates you specify.

Select the cells you want to enter numbers into. Click Home > Number Format > Text....If you only have a few numbers to enter, you can stop Excel from changing them into dates by entering: A space before you enter a number.An apostrophe (') before you enter a number, such as '11-53 or '1/47.

Convert Date to Text using Text to Column Go to Data ?> Data Tools ?> Text to Column. This would instantly convert the dates into text format. Note: There is a difference in the format of the dates in the two columns. While the original format had dd mmm, yyyy format, the result is dd-mm-yyyy.

MMM/DD/YY. Three-letter abbreviation of the month, separator, two-digit day, separator, two-digit year (example: JUL/20/99) YYYY/MMM/DD. Four-digit year, separator, three-letter abbreviation of the month, separator, two-digit day (example: 2003/JUL/25)

Convert Date to Text using Text to Column Go to Data ?> Data Tools ?> Text to Column. This would instantly convert the dates into text format. Note: There is a difference in the format of the dates in the two columns. While the original format had dd mmm, yyyy format, the result is dd-mm-yyyy.

You just need to format your strings properly ( 'YYYY-MM-DD HH:MI:SS' ) before passing them to the database, and MySQL will happily treat them as dates.

Copy the dates that are in the cells that you want to convert. Copy the text and paste it into Notepad. Return to Excel and pick the cells into which you wish to paste the dates. Go to Home ?> Number and pick the Text format with the cells chosen (from the drop down).