Format Formula not Working in Crystal report while Excel Exp

We have application where we have used Crystal Report for Reports. We have formatted one Field on Report which displaying as expected if we view it as Report. But if we are exporting it as  Excel the formatting on the concerned field is not applied and we are getting old data instead of formatted data. Please let me know where we need to do formatting of any field to make it applicable for Report View and Export options.

 

Any Help appreciated.

 

Regards,

 

Vikram