Adding “days” to a cell in Excel 2007

5 pts.
Tags:
Excel 2007
Excel 2007 functions
Excel worksheets
Windows 7
I have a list of # of days' inventory for a product and wish to add "days" to each cell. For example, "29" would appear as "29 days", with the numerical value unchanged, so my formulas still work. How do I do this?

Software/Hardware used:
Windows 7, Microsoft Excel 2007
ASKED: October 5, 2010  4:37 AM
UPDATED: January 19, 2012  4:13 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

How about, rather than trying to mix a number and text in the same cell, put another column behind that one. In that new column, put in a formula that looks like =IF(A8<>”",”days”,”") I had put this formula in cell B8. It looks at the cell to its left, A8. If there is nothing in that cell, B8 will also have nothing, but if there is something in A8 then B8 will say “days”. Looks good without confusing the number in cell A8.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • AsHappyAs
    The easiest way to do this is probably as per the previous answer, but to get exactly as you want you could try custom formatting of the column you wish to place the numbers into. Select the column, format cells, custom; at this point you select say #,##0 and then in the Type: Box add a space and then "days". You end up with #,##0 "days" as a new custom format. Typing only the numbers would then add days automatically.
    75 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following