Custom Number Format

[dschemmel]

I want to display a column of numbers with " representing inches. I cannot type this into the cell directly as excel will not recognize them as numbers for my formula that I need. How would I go about this? Thanks for any help in advance!

 

[Special-K99]

Use CHAR(34) ?

Ahh, just understood what youre trying to do, this probably wont work then.

 

[wideboydixon]

I think you might need a backslash between the 0 and the quote but I can't seem to post it here without it being removed:

0[backslash]"

WBD

 

[Marcelo Branco]

Try

Custom format
0 \ "
(without the spaces around backslash)

M.

 

[dschemmel]

I think you might need a backslash between the 0 and the quote but I can't seem to post it here without it being removed:

0[backslash]"

WBD

This worked, thanks!