Newbie Help for Custom Number Formats

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

-- joshb416

joshb416's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28851 View this thread: http://www.excelforum.com/showthread.php?threadid=486011

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

-- Kind regards,

Niek Otten

"joshb416" joshb416.1ynp8y_1132256706.1689@excelforum-nospam.com wrote in message news:joshb416.1ynp8y_1132256706.1689@excelforum-nospam.com... >

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

-- joshb416

---

joshb416's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28851 View this thread: http://www.excelforum.com/showthread.php?threadid=486011

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

>

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

-- joshb416

---

joshb416's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28851 View this thread: http://www.excelforum.com/showthread.php?threadid=486011