Displaying items by tag: excel formula

In this article, you will find a simple way to format CSV dates ready to import in mySQL database

Exported date fields from mySQL become strings in Excel CSV as follows 01/05/2016 00:00, The following simple tutorial explains how to convert the dates back into MySQL format

In this article, you will learn the formula to change text to lower case and replace space by a dash.

This can be useful when importing CSV file to a CMS like Joomla where articles titles need their respective aliases to be in lower case.

In this article, I reveal step by step instructions to convert a 10 digit number unix timestamp into a date in Excel. This is particularly useful to Joomla users as Joomla stores and exports date as Unix Timestamps.

Unix timestamp is defined as the total number of seconds since midnight (GMT time) on January 1, 1970 - also known as the Unix epoch.