Add the inches symbol after text

I would like to have the cell read an entry with the inches symbol at the
end. I have the cell set up so I can enter the decimal fraction (eg. 4.75),
and the cell converts it to a fraction (4 3/4), but I would also like the "
at the end of the 4 3/4, so it reads like this....4 3/4".

Does anybody have any suggestions?
Thank you in advance.

Michael

Good question. Use:

# ?/?"''" as the Custom Format. Note this is a double quote, two single
quotes and finally another double quote.

--
Gary's Student


"Winnipeg Michael" wrote:

> I would like to have the cell read an entry with the inches symbol at the
> end. I have the cell set up so I can enter the decimal fraction (eg. 4.75),
> and the cell converts it to a fraction (4 3/4), but I would also like the "
> at the end of the 4 3/4, so it reads like this....4 3/4".
>
> Does anybody have any suggestions?
> Thank you in advance.
>
> Michael

Holy Crap, it worked!
I tried something similar to your suggestion, but didnt use single quotes -
I used the double quotes (thought it made sense to use the double quotes).

Thanks, Gary''s Student!!!!!!

Michael




"Gary''s Student" wrote:

> Good question. Use:
>
> # ?/?"''" as the Custom Format. Note this is a double quote, two single
> quotes and finally another double quote.
>
> --
> Gary's Student
>
>
> "Winnipeg Michael" wrote:
>
> > I would like to have the cell read an entry with the inches symbol at the
> > end. I have the cell set up so I can enter the decimal fraction (eg. 4.75),
> > and the cell converts it to a fraction (4 3/4), but I would also like the "
> > at the end of the 4 3/4, so it reads like this....4 3/4".
> >
> > Does anybody have any suggestions?
> > Thank you in advance.
> >
> > Michael

You ae very welcome
--
Gary's Student


"Winnipeg Michael" wrote:

> Holy Crap, it worked!
> I tried something similar to your suggestion, but didnt use single quotes -
> I used the double quotes (thought it made sense to use the double quotes).
>
> Thanks, Gary''s Student!!!!!!
>
> Michael
>
>
>
>
> "Gary''s Student" wrote:
>
> > Good question. Use:
> >
> > # ?/?"''" as the Custom Format. Note this is a double quote, two single
> > quotes and finally another double quote.
> >
> > --
> > Gary's Student
> >
> >
> > "Winnipeg Michael" wrote:
> >
> > > I would like to have the cell read an entry with the inches symbol at the
> > > end. I have the cell set up so I can enter the decimal fraction (eg. 4.75),
> > > and the cell converts it to a fraction (4 3/4), but I would also like the "
> > > at the end of the 4 3/4, so it reads like this....4 3/4".
> > >
> > > Does anybody have any suggestions?
> > > Thank you in advance.
> > >
> > > Michael

This works. So if you type in: 6.5 you want this to come out 6 1/2".

# ??/?"''"