Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Put in text after a calculation
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 -- N/A |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Put in text after a calculation
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" -- David Biddulph "Joel" wrote in message ... 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 -- N/A |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Put in text after a calculation
Hi Joel,
=H20-E20&" days" HTH Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text box positioning, printing and between loads | Charts and Charting in Excel | |||
How can I fill a series in Nonadjacent cells eg Text 1, Text 2 | Excel Discussion (Misc queries) | |||
Calculation within Text | Excel Worksheet Functions | |||
Can a calculation ignore text if it occurs in formula's cell range | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |