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

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

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

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


"horseman" wrote in message
...
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