Excel - Quotation Marks in Custom Number Formats 2

[reichertc]

I know I've done it before but I can't remember how!!!

I want to type in a number in a cell and have it displayed with a trailing double quotation mark. For example, enter the number 3 and have it appear as:

3"

I'm fairly certain I need to use the char() function somewhere.

Any help??

 

[meintsi]

Change your format to CUSTOM and use this: #''

The double quotes create the error so use two single quote marks. *Remember.......
If you don't use your head,
your going to have to use your feet.

 

[jbuchanangb]

Well done, meintsi.

the use of # causes integer rounding, but the trailing two single quotes works at the end of General also, so the format General'' works better

 

[reichertc]

Hmm... Look pretty good when I am using Arial as a font, but when I use a font like Letter Gothic, it doesn't look so nice anymore.

If need be, I'll use a font that looks nice, but I know there is a better way to do this...

 

[reichertc]

Ah ha!

Use the backslash in the custom format. eg.

#.###\"

Now it works with any font.

Thanks for the suggestions.