How to convert date to number or text in Excel?

Select a cell next to your date data, and type this formula =TEXT(A1,”dd/mm/yyyy”) into it, then press Enter key. If you need, you can drag the fill handle to apply this formula in a range.

Source: How to convert date to number or text in Excel?

Advertisements
This entry was posted in Compus and tagged , , . Bookmark the permalink.