Forum Discussion

ryan thompson's avatar
ryan thompson
Copper Contributor
Feb 28, 2018

Problems with formating text within a cell.

Hiya,

 

Is there a way to use a formula in a cell, then have units in that same cell.  Ie I would like for the cell to be the sum of 2 other cells, then a unit like mm or inches.  Is there a way to do this?

 

Thanks,

 

Ryan

excel

1 Reply

Sort By
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Feb 28, 2018

    Ryan,

     

    You can use either this formula: 

    =SUM(A2:B2)&" mm"

    Or this custom format:

    0 "mm"

    To apply this format, select the cells, press Ctrl+1, go to Custom, Copy the format into the Type box, and then Hit OK. 

     

    Please find the attached file.

Resources