I'm trying to display a number in a cell in a specific way that is referencing another cell where that cell is formatted as:
![Capture430.JPG Capture430.JPG](https://www.mrexcel.com/board/data/attachments/113/113446-92efc57372a50c0a09740c1a1ec408cc.jpg)
source cell (N15) is formatted as: Custom - 'dd:hh:mm:ss'
the target cell (N11) is formatted as: Custom - 'd'.
Although this cell DOES give me the right number (after I reduce the decimal place down to one place, shown where circled in green), when in cell N1 I reference that cell using this formula: =N19&" ("&N11&")" (where N19 is is cell formatted as text and contains a persons name), it returns what is shown in the pic. But what I would like it to say is:
![Capture432.JPG Capture432.JPG](https://www.mrexcel.com/board/data/attachments/113/113448-71123a59920003d99daca27cb555e4ee.jpg)
Any help?
Thanks so much![Thumbs up (y) (y)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
![Capture430.JPG Capture430.JPG](https://www.mrexcel.com/board/data/attachments/113/113446-92efc57372a50c0a09740c1a1ec408cc.jpg)
source cell (N15) is formatted as: Custom - 'dd:hh:mm:ss'
the target cell (N11) is formatted as: Custom - 'd'.
Although this cell DOES give me the right number (after I reduce the decimal place down to one place, shown where circled in green), when in cell N1 I reference that cell using this formula: =N19&" ("&N11&")" (where N19 is is cell formatted as text and contains a persons name), it returns what is shown in the pic. But what I would like it to say is:
![Capture432.JPG Capture432.JPG](https://www.mrexcel.com/board/data/attachments/113/113448-71123a59920003d99daca27cb555e4ee.jpg)
Any help?
Thanks so much