special formulas
Why not use /" (slash/double quote mark) in the format pattern to put the
"inch" symbol at the end of the fraction?
--
Rick (MVP - Excel)
"Luke M" wrote in message
...
Custom format
###/###''
will accomadate up to 3 digit fractions. Note that it uses 2 single
quotation marks, not 1 double quotation mark.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Tacklemom" wrote:
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
--
Donna
|