The text function is a nifty little feature in Excel that will allow us to make our reports crisp. Have you ever added a column for the sole purpose of putting “per hour” behind a dollar amount? Have you ever wanted to put the day of week next to a date? The TEXT function in excel will let you do that easily.
http://office.microsoft.com/en-us/excel-help/text-function-HP010062580.aspx