Combine data from multiple columns to single column (Format changes)

[taralmehta15]

Hi friends,

I am trying to combine multiple columns to single column and having a bit trouble with it at 2 places.

1- Combining 2 columns (1st column with discount % and 2nd with Discount (In Rupees)) into a single column. I do get the combined result but not the format. what I get is 0.1 (Instead of 10%) and Rs 10 (Instead of Rs 10.00)

2-Combining 3 columns (1st column With Batch Number, 2nd column with Manufacture date and 3rd with Expiry date). Here also the date format changes. Mfg date and Exp date are in MMM-YY formate but after combining them to single column the format changes to dd/mm/yyyy

Please Login or Register  to view this content.

I have attached a sample file here.
Thanx a lot...

[Fluff13]

How about

Please Login or Register  to view this content.

[Vraag en antwoord]

Make use of format.

[SjonR]

like this?

Please Login or Register  to view this content.

[taralmehta15]

How about

Please Login or Register  to view this content.

Dats awesome.. I spent quite a bit of time on it. Dint knew dis could be done so quick. Thanx a lot for this.. Reps added...

[Fluff13]

Glad to help & thanks for the feedback

[taralmehta15]

like this?

Please Login or Register  to view this content.

Thanx a lot for dis code.. Reps added...