If you find it worth the trouble, think the result cell could be "dressed
up" to appear as desired, via a disguised textbox which sits
directly/exactly over the result cell.

Here's the play ..

Assume From2, To2 are named ranges referring to A1 & B1 respectively, and
that C1 contains just:
=TEXT(From2,"mm/dd/yyyy")&" - "&TEXT(To2,"mm/dd/yyyy")

Draw a textbox to fit exactly over C1
(hold down Alt key to resize/fit to grid)

Right-click on textbox Format textbox Colors and Lines tab
Set the Fill to: No Fill, Line color to: No Line

Enter the text: "Time Period:"
Set the font to bold (or whatever you want)
and Text alignment to "Horizontal: Left"

Stretch / resize C1 (i.e. col C) so that both the text in the textbox
and the result in C1 shows through
(Right-align the evaluated value in C1)

If A1 contains: 01-May-2005, B1 contains: 02-May-2005
then C1 will appear as:
Time Period: 05/01/2005 - 05/02/2005
(with "Time Period:" in bold/formatted as desired)

Note tha with the textbox fitted over C1,
you need to use the arrow keys to navigate to select cell C1

Sample file for the above is at:
http://flypicture.com/p.cfm?id=44172
(right-click on the link "Download File" at the top of the page)
File: KimberlyC_wksht.xls

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"KimberlyC" wrote in message
...
Hi,
Is there a way to add formatting to this formula to make the "Time Period:
"
bold and leave the rest of it in regular text?

="Time Period: "& TEXT(From2,"mm/dd/yyyy")&" - "&TEXT(To2,"mm/dd/yyyy")

Thanks in advance for you help!!
Kimberly