If someone still looking for answer, belowthe line below worked perfectly for me
I appendedentered =("my_value")=("my_value").
i.e. =("04SEP2009")=("04SEP2009") displayed as 04SEP200904SEP2009 not as 09/04/200909/04/2009
The same worked for integers more than 15 digits, they. They weren't getting trimmed anymore.