Export from CR to a csv file

[FireBott]

This might not be the right Forum or message board to post this, but I am at a loss and need to start somewhere. I am generating a Crystal Report from our payroll system. From the CR I need to export the data to a csv file. This is my problem, in my CR I had to create a formula field to generate four zero's (0000). But when I export it as a csv file three of the zero's get dropped. How can I export this to show the four zeros in the csv file.

Thanks for anyones help or reference