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...o&userid=28851
View this thread: http://www.excelforum.com/showthread...hreadid=486011

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

--
Kind regards,

Niek Otten

"joshb416" wrote in
message ...

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...o&userid=28851
View this thread: http://www.excelforum.com/showthread...hreadid=486011

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

"joshb416" wrote:


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...o&userid=28851
View this thread: http://www.excelforum.com/showthread...hreadid=486011