Microsoft Excel - adding text after a number - Asked By Benoit on 31-Jan-11 06:53 PM
The result should be a number, How do I add the text "Year(s)" after each number
So instead of seeing
I want to see
John D replied to Benoit on 31-Jan-11 07:27 PM
Try it this way =IF(I$22="","",I$22&"Year")
Jackpot . replied to Benoit on 31-Jan-11 08:33 PM
Another way is to format the cells to Custom format. (Right click>FormatCells>Custom>Enter as below)...
This will allow you to use the number in that cell to be used for any other calculations.
Benoit replied to John D on 01-Feb-11 01:43 AM
That did the trick