Format Cells to Include Text in Microsoft Excel

Suppose you want to enter a value, but you want it to show up in the cell with its measure behind it.

In the following example, I use custom formatting to always display the value with "gals" (gallons) behind it.