How do I format a cell for " inches

I need to enter 1 2 3 and get
1" 2" 3", etc....
How do I format a cell to display inches

--
Dave

Try inserting a Custom format using the # sign followed by two
apostrophes, ie: #''

How can I get that to work for fractions
I want the value of 0.50 to display as 1/2"


--
Dave

"Jim" <[email protected]> wrote in message
news:[email protected]...
> Try inserting a Custom format using the # sign followed by two
> apostrophes, ie: #''
>

Try this custom format: # ?/?''

That's 2 single apostrophes at the end

perfect
thankx

--
Dave

"Cutter" <[email protected]> wrote in
message news:[email protected]...
>
> Try this custom format: # ?/?''
>
> That's 2 single apostrophes at the end
>
>
> --
> Cutter
> ------------------------------------------------------------------------
> Cutter's Profile:
http://www.excelforum.com/member.php...fo&userid=9848
> View this thread: http://www.excelforum.com/showthread...hreadid=500910
>

Great format... also #.##'' to round to a digit. Thank Cutter