date format problem when using a formula

[snsyg]

hi all,

i am having a problem with the date format in a cell that contains th
following formula:

="Work in accordance with proposal dated "&Proposal_Date

Proposal_Date being a named cell with the date format of 3/30/04.

the formula works, but the date shows up in the cell value in a numbe
format (38050).

formatting the applicable cells to the date format i want has no affec
on the cell value.

any help will be greatly appreciated.

thanks

kare

 

[Frank Kabel]

Hi
try
="Work in accordance with proposal dated "&
TEXT(Proposal_Date,"MM/DD/YY")

 

[snsyg]

hi,

thanks again, frank. it now work perfectly.

kare