Kimberly,
Use the TEXT function to convert the date serial number to a
formatted date. E.g., TEXT(From,"mm/dd/yy")
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"KimberlyC" wrote in message
...
Hi,
I'm using the following formula to combine 4 ranges into one
cell in my
worksheet.
The ranges are (Company, Employee, From, and To)
="Company: "&Company&" --- "&"Employee: "&Employee&" --
"&"Period:
"&From&"-"&To
This is working fine..expect the From and To ranges are dates
and they show
up like this below (after period)
Company: ABC --- Employee: kim -- Period:
37987-38353
These numbers should be 1/1/04 and 1/1/04
I'm not sure what to add and where to the above formula to get
the dates to
show in mm/dd/yyyy format.?
Thanks in advance for your help!!
Kimberly