I have a list of employees and the number of hours they have worked on across different projects. I want to append Unit of Measurement ("Hrs") wherever there is a number shown. I know I can do that easily using the formula
=B2& " Hrs"
but I'm also doing a pivot table where these number values are getting added (Sum). I just wanted to check if there was a way to append the text "Hrs" in the pivot table where the number values are shown without affecting the calculation?