Add a Descriptive Text to Number Formats in Excel with Example.

How to use Custom Number Formats / Combine Descriptive Text to Number Formats in MS Excel with Example / Add Text to Number Formats through Custom Format.



If you want to Combine or include descriptive Text to your Number Formats in Microsoft Excel Spreadsheet you can also use custom number formatting.

How to apply custom format to the numbers / Numeric Values or How to add a descriptive Text to Number Formats in Microsoft Excel Spreadsheet with Example?

 
To add descriptive text in your number format, write / type the text you want to display in double quotes within the number format code.

So instead of using a formula that I used in my previous post which is given below....

="Report due " & TEXT(A4,"dddd mmmm d, yyyy at h:mm am/pm")

 

 ...you can get the same result by applying this custom number format to the cell(s) containing the date/time or a number.

"Report due " dddd mmmm d, yyyy "at" h:mm am/pm

Custom Number Format

In the above example you will find that the additional text 'Report due' and 'at' are typed in double quotes within the number formatting code.

Note:- It is necessary that you type text within double quotes but you don't have to use double quotes around text that doesn't contain any of the characters that Microsoft Excel uses in its number format codes,  like 'm,d,y,h,m,s,e,@'.

To avoid any confusion or errors, it's better to ALWAYS use double quotes around descriptive text in number formatting.

One of the biggest advantages adding text to number formats is that the value in the cell(s) is not affected. You can still sort, filter, and reference the cells in your formulas.

Custom Number Format