excel-custom format using inches symbol (")

N

nannieree

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

Thank you
 
J

JE McGimpsey

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

Format/Cells/Number/Custom 0\"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete all data after a symbol in a field 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Excel does not accept text format! 0
How do I add " to the right of a number when formatting? 4
MS Project Center-Autolink column fields 0
Is it possible to display feet and inches in one cell ? 4
Visio 2016 - Single exterior wall with multiple thicknesses 1
ASK Field Formatting 1

Top