Formatting mixed text and links

[Jonibenj]

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???

[swatsp0p]

All you need to do is enclose your formatting instructions in quotes:

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

HTH

Bruce

[Jonibenj]

Thanks Bruce!! Why didn't I think of that?

Jonathan

[swatsp0p]

You're welcome. Sometimes it is the Forest and the Trees...

Thanks for the reply...

Cheers!

Bruce