View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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