Missing data ??

[Eee]

Hi There,

Not sure if anyone has had this before, i want to display a phrase in a cell which pulls in 2 pieces of data from other cells on an adjacent sheet.
The cell contains the following:

="Thank you for your Purchase Order Number "&TEXT(Data!C41,)&" dated "&TEXT(Data!C43,"dd mmm yyyy")&

This works fine as long as cell 'Data!C41' contains numbers and letters, or letters or symbols. However if cell 'Data!C41' only contains numbers then the phrase omits the number. I would like the phrase to reproduce exactly what is shown in cell 'Data!C41'

Can this be resolved ?

[EdMac]

What happens if you omit "Text"

Ed

[Eee]

Thanks Edmac.........

I removed 'TEXT' and the brackets and it works fine now

You've made an old man happy today

[EdMac]

From one old man to another

"simple things work best"

Ed