special formulas

T

Tacklemom

Hi All,

what I am trying to do is attach the " sign to a cell. So when you enter in
a fraction eg (1/4) which I have already formatted for you attach the " sign
with it. Any suggestion?

Thanks
 
S

Shane Devenshire

Hi,

Here are two ways to do this both involve custom formats

Choose Format, Cells, Number tab, Custom and on the Type line enter either
General"''"
or
General\"

In the first case there are two single quotes between the pair of double
quotes, in the second case it ends with a single double-quote.

You can change General to any standard number format number format you want.
 
L

Luke M

Custom format
###/###''

will accomadate up to 3 digit fractions. Note that it uses 2 single
quotation marks, not 1 double quotation mark.
 
R

Rick Rothstein

Why not use /" (slash/double quote mark) in the format pattern to put the
"inch" symbol at the end of the fraction?
 
Top