Using MS Excel Office 2003. I want to link the values of two separate cells
of Sheet 1 to one cell of Sheet 2 separated by a slash. I want it to look
like a fraction, but I do not want it to reduce the fraction.
Using MS Excel Office 2003. I want to link the values of two separate cells
of Sheet 1 to one cell of Sheet 2 separated by a slash. I want it to look
like a fraction, but I do not want it to reduce the fraction.
=sheet1!a1 & "/" & sheet1!a2
If you want to format the numbers, you can do something like:
=text(sheet1!a1,"000.0") & "/" & text(sheet1!a2,"00000")
Peri wrote:
>
> Using MS Excel Office 2003. I want to link the values of two separate cells
> of Sheet 1 to one cell of Sheet 2 separated by a slash. I want it to look
> like a fraction, but I do not want it to reduce the fraction.
--
Dave Peterson
Hi!
Try this:
=Sheet1!A1&"/"&Sheet1!A2
Biff
"Peri" <[email protected]> wrote in message
news:[email protected]...
> Using MS Excel Office 2003. I want to link the values of two separate
> cells
> of Sheet 1 to one cell of Sheet 2 separated by a slash. I want it to look
> like a fraction, but I do not want it to reduce the fraction.
Thank you, Dave! It worked!
"Dave Peterson" wrote:
> =sheet1!a1 & "/" & sheet1!a2
>
> If you want to format the numbers, you can do something like:
> =text(sheet1!a1,"000.0") & "/" & text(sheet1!a2,"00000")
>
>
>
> Peri wrote:
> >
> > Using MS Excel Office 2003. I want to link the values of two separate cells
> > of Sheet 1 to one cell of Sheet 2 separated by a slash. I want it to look
> > like a fraction, but I do not want it to reduce the fraction.
>
> --
>
> Dave Peterson
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks