Put in text after a calculation

J

Joel

Hi to one and all

I have a silly question I am hoping someone can answer.

I am calculating between 2 dates and in the calculation result box I want
the answer wich I have done. At the end of the calculations I want it to give
the number of days and says days at the end of it

Example at the moment it says 2 but I wish it to say 2 days

Here is my calc

=H20-E20

Regards Joel
 
D

David Biddulph

You could custom format that =H20-E20 answer as 0 " days"
or if you want the answer to be text rather than a number you can use
=H20-E20&" days"
 
Top