Convert a Text Date to Numeric Date
How to convert Text Date to Numerical Date? For this Excel is the best tool to do the job, and there is two techniques.
Date format
How to display hours over 24
Discover how you can display time over 24 hours in your worksheets. You just have to customize the number format of your cells.
Change the default Date format in Excel
How to change the default Date format when you insert a date in a cell. The technique is explained in this article
Date Format in Excel
Discover how to customize easily your date format in Excel by changing the day, month or year. Many example.
Excel Split Date and Time
How to split date and the time with Excel? With just to simple formulas, you can extract them in 2 different columns
Add Days Excluding the Weekend
How to add days to a date excluding the weekend? In Excel, one function exists to do the job without mistakes.
Function DATE – YEAR – MONTH – DAY
The function DATE is very useful to create your custom dates. This article will explain you how the function works
Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde
How to convert the GPS coordinates (latitude- longitude) in degree, minute, seconde and also the other way round. The solution is the custom number format.
