Formatting cells to put the " mark for inches?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to do that? I have tried to make it Special, Number and
General but it doesn't accept that.
 
Try entering the following formula in the "Custom" category:

#\"

The backslash tells Excel to treat the following character as a literal.
 
You must log in or register to reply here.

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

Excel How To Convert Decimal To Inches 2
Tablet size: I love the 8 inches 1
Convert Decimal to Feet and Inches 2
Display entire number in cell 3
Number stored as text 4
Add an inches sign to many rows 5
Change Inches to feet and Inches 3
Cant seem to get this to work 1

Back
Top