Excel 2007 show text with today's date

[Tony O]

I am using Excel 2007 to create my reports.

I am currently using the top cell to say:
"Report for " and then today's date
so for this past Friday, it would be in this format:
"Report for 05-04-12"

I type this in every business day.

I know that if I type
=now()
the cell shows the date and time.

I tried
="Report for "& now()
It shows "Report for 41035...."

Please advise how to have Excel show it in this format:
"Report for 05-04-12"
by using a formula.

 

[Ron Rosenfeld]

I am using Excel 2007 to create my reports.

I am currently using the top cell to say:
"Report for " and then today's date
so for this past Friday, it would be in this format:
"Report for 05-04-12"

I type this in every business day.

I know that if I type
=now()
the cell shows the date and time.

I tried
="Report for "& now()
It shows "Report for 41035...."

Please advise how to have Excel show it in this format:
"Report for 05-04-12"
by using a formula.

Two methods:

A1: ="Report for " & text(today(),"mm-dd-yy")

Perhaps easier to custom format the cell.

A1: =today() (or any real date)

Format Cells/ Number /Custom
Type: "Report for "mm-dd-yy