One way is to use the escape sequence \<character:

Format/Cells/Number/Custom 0\"

In article ,
nannieree wrote:

I am using Excel and need to know how to create a custom format that adds the
symbol for inches next to a number.