![]() Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. If you have Kutools for Excel, its Apply Date Formatting function will do you a big favor. If you want to use formula to convert date to year/month/day only, you can do as below:Ĭonvert date to different format with Apply Date Formatting Click the OK button to apply the new format. In the Format Cells dialog, under Number tab, select Date from Category list, and then select one format you want to convert to from the right section.ģ. Select the dates you want to convert, right click to select Format Cells from context menu.Ģ. In Excel, you can convert date to other date format in the Format Cells function.ġ. If you want to convert the standard date to other date formats in Excel, how can you do? Here, I have three methods that can solve this job.Ĭonvert date to different format with Format CellsĬonvert date to different format with formulasĬonvert date to different format with Apply Date Format How to convert date to different or specific format in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |