Tag Archives: convert

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 … Continue reading

Posted in Compus | Tagged , ,