PDA

View Full Version : [SOLVED] concatenate formula



Veeru
09-06-2017, 09:45 PM
Hi,

My issue is not big but I need it on urgent basis. I am trying to use concatenate formula on three items.

1. 1900 (Amount)
2.07-09-2017 (Date)
3. 12.78 (Amount)

When applying concatenate , it converts date into numbers hence result is something like this : 19004298512.78

But what I need is data format should be maintain and result should be like : 190007-09-201712.78

Please provide suggestion on the same.

Thanks

Bob Phillips
09-07-2017, 12:06 AM
=A2&TEXT(B2,"dd-mm-yyyy")&TEXT(C2,"#,##0.00")

Veeru
09-07-2017, 10:20 AM
Yes that is working...Thanks a ton..