Add Text To Displayed Excel Numerical Value

Home
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010



How to add text to an Excel numerical value so that it is still treated as a numerical value with which you can perform all kinds of calculations like sum, average, etc. Many people like to see the numerical quantity with some text so that they can easily know what that quantity relates to. For example, if I'm an exporter I would prefer to see '12 silver stands' as inventory than just '12' without scrolling through the whole Excel worksheet. If I'm dealing in foreign exchange and using calculations to convert one currency into another I would prefer to see '120 AUD' (AUD = Australian Dollar) multiplied by a factor than just '120'  multiplied by a factor. Also I would prefer to add quantities and see the result as '5400 AUD' than just '5400'.
The process of adding custom text to a numerical in Excel is easy and offers great advantages. We use quotes to add the text.

Watch the training video below to learn how add text to numerical values in Microsoft Excel:



Can you also have a format that will vary based on the value in the cell? For example you may wish to display 'pc' for a single piece of quantity and 'pcs' for many pieces of an item. Yes this can also be acieved easily in MS Excel by using spefic conditions before the word 'General'. For example, you could use the format: [>1] General " pcs";[=1]General" pc" to display 'pcs' if the value in the cell is greater than 1 and 'unit' if the value in the cell is 1.

add specific text to numerical excel value add-specific-text-to-numerical-value-result
Text Display based on condition
Display Result

Home
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010