How? Link 2 cells from Sht 1 to 1 cell in Sht 2 separated w slash

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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")
 
Thank you, Dave! It worked!

Dave Peterson said:
=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")
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display "/" (slash) as a character, not as an action (divide) 4
Scrabble Value calculation for Welsh words 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Named Range maker code 9
conditionally format based on intersheet cell comparisons 1
separating date and time 5
Text fraction to fraction format 1
Update cell value based on name and specific date 1

Back
Top