Text with date concatenate problem

[nur2544]

Dear all, I am having problem with concatenate formula. Here is my issue

Please Login or Register  to view this content.

Here date format is DD-MM-YYYY

[DBY]

Hello
Try:

=A2&" : "&TEXT(B2,"dd-mm-yyyy")

Assuming B2 is date value.

Hope this helps.
DBY

[ragulduy]

=A2& " : " & TEXT(B2,"DD-MM-YYY")
in C2

[nur2544]

Hi DBY & yudlugar, thanks for replay. it works very well. & sorry for bother once again , here I have mistake one things , if cell: B2 having no data then will be blank , I mean like below

Please Login or Register  to view this content.

but currently it is showing as
ABBANK : 00-01-1900

[ragulduy]

=a2& " : " & if(not(b2=""),text(b2,"dd-mm-yyy"),"")

[nur2544]

Hi yudlugar , I really appreciate your nice job. Many thanks for your valuable time…