Forum Discussion

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 ...

excel

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.