Black Friday Sale!

Ends in:

Use Formatted Dates and Numbers within Other Text in Excel

Add to Favorites
Author: | Edits: don
BLACK FRIDAY SALE (65%-80% Off)

Excel Courses Online
Video Lessons Excel Guides

How to put dynamic formatted dates and numbers into text in Excel.

This allows you to have a number or date or any value that can be updated and changed, such as a date or dollar amount or hours worked, and be able to display that value nicely, and in the correct format, within other text in Excel.

This trick uses the TEXT() function with custom formatting rules in Excel.

Resources

Text Function for Excel (Microsoft Link)


Excel Function: TEXT()
Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Generate Random Numbers within a Range in Excel
Tutorial: How to generate random whole numbers (integers) that are between two numbers.  This allow...
Count the Number of Cells that Contain Specific Text in Excel
Tutorial: How to count the number of cells that contain specific text within a spreadsheet in Excel....
Format Cells as Text in Excel
Macro: This free Excel macro formats a selection of cells as Text in Excel. This macro applies th...
CHOOSE Function in Excel
Tutorial: Return a value from a list of values. This is like a mini-lookup function that contains a...
Count the Number of Cells that Start or End with Specific Text in Excel
Tutorial: How to count cells that match text at the start or the end of a string in Excel. If you w...
REPT Function in Excel - Repeat Values
Tutorial: Quickly repeat a value, character, or number within a cell in Excel.  This is a neat li...
Tutorial Details
Excel Function: TEXT()
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course