Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How? Link 2 cells from Sht 1 to 1 cell in Sht 2 separated w slash
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How? Link 2 cells from Sht 1 to 1 cell in Sht 2 separated w slash
=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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How? Link 2 cells from Sht 1 to 1 cell in Sht 2 separated w slash
Hi!
Try this: =Sheet1!A1&"/"&Sheet1!A2 Biff "Peri" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How? Link 2 cells from Sht 1 to 1 cell in Sht 2 separated w sl
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
How do I total range of cells that have checks in checkboxes? | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |