Newbie Help for Custom Number Formats

[joshb416]

Hey All,

I am working on a spreadsheet that I would like to have it append the
inch symbol as part of the number format ("). I figured out that I can
add custom suffixes with the use of the quotation marks, but I can't
place a quotation mark inside of quotes and get what I need. Is there
any way to have Excel do this for me?

I know it seems like a small thing to do, but having Excel add this for
me would save me a lot of time with formulas and all.

Example: 24"

Thanks in advance.

JB

 

[Niek Otten]

There may be other ways, but you could place two single quotes between
quotes

 

[Guest]

It looks like a custom format of #\" does the trick.