What is TEXT function in Excel?
TEXT function is one of Microsoft Office Excel TEXT
… Read MoreHow to join date and text together in Excel
To join a date with text, you can use concatenation with the TEXT function to … Read More
How to show last updated date stamp in Excel
To add a date stamp in a workbook to indicate a “date last updated”, you … Read More
Pad week numbers with zeros in Excel
To pad week numbers (or any number) with zeros using a formula, you can use … Read More
How to convert numbers to text using TEXT function in Excel
To convert numbers into text values, you can use the TEXT function.
Normally, you want … Read More
Convert date to Julian format in Excel
This tutorial shows how to Convert date to Julian format in Excel using example below.… Read More
Convert date to month and year in Excel
This tutorial shows how to Convert date to month and year in Excel using example … Read More
Convert date to text in Excel
This tutorial shows how to Convert date to text in Excel using example below.
If … Read More
Create date range from two dates in Excel
This tutorial shows how to Create date range from two dates in Excel using example … Read More
Count dates in current month in Excel
This tutorial shows how to Count dates in current month in Excel using example below.… Read More
Get days, hours, and minutes between dates in Excel
To calculate and display the days, hours, and minutes between two dates, you can use … Read More
Get day name from date in Excel
If you need to get the day name (i.e. Monday, Tuesday, etc.) from a date … Read More
Get month name from date in Excel
If you need to get the month name (i.e. January, February, March, etc.) from a … Read More
Convert Numbers to Text in Excel
By default, numbers are right-aligned and text is left-aligned in Excel.
This example teaches you … Read More