Formatting and alignment of Value based on the expression

[#1]

Hi,

I am having a column with the name Value,in the value column i am having different format of data like string date and numbers.

Value Field(Column):

10-03-2016

12-09-2016

ABC

DEF

100

200

ABC-100

DEF-200

I want to show all the values in the pivot using expression.

When i am using SUM(Value) then only getting numbers and when using purgechar then not getting date.Pls help me for expression which will handle all the values accordingly.

[#2]

I tried =VL in an expression but the VL is a Varchar field which contains dates,strings and numbers as well.

If possible please share your contact number or you can reach me at 9030444224