Home » Category » Microsoft Excel

Microsoft Excel: Adding text to a formula

205| Thu, 22 May 2008 18:42:00 GMT| anonymous| Comments (3)
I am using execl 2000. In my spreadsheet I have to calculate how many days it
takes to send out requests from receiveing them. I have set up a formula
which takesaway the date the request was sent out from the data the request
was received. So if the dates in the requests field received and requests
field sent are the same it will show 0, if the dates are different by 1 day
it will show as 1 etc. Is their any way that I can enter text into the
formula so that it will put day in Eg: 0 Day, 1 Day, 2 Day etc

Keywords & Tags: adding, text, formula, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/14999/
 
«« Prev - Next »» 3 helpful answers below.
Yes:

puull-down:
Format > Cell... > Custom and enter
General & " Day"
in place of General
--
Gary's Student

"horseman" wrote:

> I am using execl 2000. In my spreadsheet I have to calculate how many days it
> takes to send out requests from receiveing them. I have set up a formula
> which takesaway the date the request was sent out from the data the request
> was received. So if the dates in the requests field received and requests
> field sent are the same it will show 0, if the dates are different by 1 day
> it will show as 1 etc. Is their any way that I can enter text into the
> formula so that it will put day in Eg: 0 Day, 1 Day, 2 Day etc

garysstudent | Thu, 22 May 2008 18:43:00 GMT |

Try =(A1-B1)&" days"
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address

"horseman" <horseman...discussions.microsoft.com> wrote in message
news:84417BD6-513A-4039-8784-A76528017840...microsoft.com...
>I am using execl 2000. In my spreadsheet I have to calculate how many days
>it
> takes to send out requests from receiveing them. I have set up a formula
> which takesaway the date the request was sent out from the data the
> request
> was received. So if the dates in the requests field received and requests
> field sent are the same it will show 0, if the dates are different by 1
> day
> it will show as 1 etc. Is their any way that I can enter text into the
> formula so that it will put day in Eg: 0 Day, 1 Day, 2 Day etc

bernard | Thu, 22 May 2008 18:45:00 GMT |

Thanks for that

"Gary''s Student" wrote:

> Yes:
> puull-down:
> Format > Cell... > Custom and enter
> General & " Day"
> in place of General
> --
> Gary's Student
>
> "horseman" wrote:
> > I am using execl 2000. In my spreadsheet I have to calculate how many days it
> > takes to send out requests from receiveing them. I have set up a formula
> > which takesaway the date the request was sent out from the data the request
> > was received. So if the dates in the requests field received and requests
> > field sent are the same it will show 0, if the dates are different by 1 day
> > it will show as 1 etc. Is their any way that I can enter text into the
> > formula so that it will put day in Eg: 0 Day, 1 Day, 2 Day etc

horseman | Thu, 22 May 2008 18:46:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories