How do I add " to the right of a number when formatting?

[KSstudent]

I am trying to format a column of numbers example.
0.152
0.025
I have figured out how to remove the first zero now I need to add a single
quotation mark the symbol for inches. I do not know how on the custom
formatting I just get an error.

 

[T. Valko]

What does your format look like that removes the leading 0?

This custom format will add the " but does not remove the leading 0:

General"''";-General"''"

Note that the quotes are a double quote then 2 single quotes then another
double quote.

" ' ' "

Biff

 

[Joerg]

Single quote, surrounded by double quotes, at the end of your custom format.

Joerg

 

[Niek Otten]

Format Custom as .000"'" (Quote, single quote, quote)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am trying to format a column of numbers example.
| 0.152
| 0.025
| I have figured out how to remove the first zero now I need to add a single
| quotation mark the symbol for inches. I do not know how on the custom
| formatting I just get an error.
|

 

[KSstudent]

Thank you: I was putting double quote double quote double quote now I see
the error.