I have a linking formula in a cell which is meant to display a mixture of set text and a linked date from another sheet. How do I make the date display in the correct format? The format I want to use is "dd-mmm-yyyy". The set text is "HD_DD ". The linked cell that I want is C72 on a sheet called "Info". I wrote this formula:

="HD_DD "&TEXT(Info!C72,dd-mmm-yyyy)

All I get for this is #NAME? What am I doing wrong???