D
David Allen
I need to enter 1 2 3 and get
1" 2" 3", etc....
How do I format a cell to display inches
1" 2" 3", etc....
How do I format a cell to display inches
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim
Try inserting a Custom format using the # sign followed by two
apostrophes, ie: #''
apostrophes, ie: #''
D
David Allen
How can I get that to work for fractions
I want the value of 0.50 to display as 1/2"
I want the value of 0.50 to display as 1/2"
C
Cutter
Try this custom format: # ?/?''
That's 2 single apostrophes at the end
That's 2 single apostrophes at the end
D
David Allen
perfect
thankx
thankx