Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
special formulas
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
special formulas
Try using this Custom Cell Format...
# ?/?\" -- Rick (MVP - Excel) "Tacklemom" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
special formulas
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
special formulas
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste special for formulas | Excel Discussion (Misc queries) | |||
Paste Special - Formulas - Add | Excel Worksheet Functions | |||
paste special - formulas | Excel Worksheet Functions | |||
Paste special formulas? | Excel Discussion (Misc queries) | |||
Paste Special - All but formulas | Excel Worksheet Functions |