If you export as Excel, there is checkbox which allows you to apply the layout-level formatting. Primary data (aka raw data) must be left without any formatting for use within other applications.
For translation which includes leading zeros, try calculation (result is text) =
Right ( "0" & Month ( date ) ; 2 ) & "/" & Right ( "0" & Day ( date ) ; 2 ) & "/" & Year ( date )
Thank you so much. I will give this a shot.
It works, Its a 10 :)
Thanks, this has helped me too!