You can use the code the others suggested. I just use the cell formatting.

Highlight your cells or your entire column. On the Home ribbon, find the section for Number formatting. I tend to first format as a Number, change to four decimal places, and then go to Custom. In the Custom pane, you can type the character you want to show behind your number. The wrinkle is the quotation mark itself is not going to work, because Excel thinks you're using a formula. So I type behind the number " (open quotation mark) then ' (apostrophe) then another ' (apostrophe), then " (close quotation mark.) The quotes frame what you want to put there, and the two sequential apostrophes appear as if a quotation mark. So, in your Custom line, it's 0.000"''". Quote-apostrophe-apostrophe-quote.

Attached Images

inches.jpg (144.5 KB, 21 views)

Depending what you want to do with the values, you could also have an additional column next to your existing one, that has, for example The cells with the double quote mark would no longer be "numbers" though, so you wouln't be able to do math with them (average, etc).

Have you tried my suggestion in post #2 ?

Yeah. Given OP's desire to leave the numerical values unchanged, just changing the formatting (as you have done), is probably what he needs. For other purposes though, changing the value could be useful. For example if he wanted a textual summary statement such as
then actually changing the value would be useful.

Though, as I write this, is accurs to me that
would also work.