How to Change Excel Cell Formatting in MAS 90

SOLVED

I would like to know if there is a way to change the default "General" cell formatting to "Text" in Sage 100 ERP (MAS90).


The issue I am having is that when I use Item Maintenance to list a product line, we have many items that have leading zeros.  These leading zeros are being excluded in Excel when I use the Export to Excel option.  I have been told this is due to the way the default cell setting is set to "General" in the cell formatting in Sage.


This is something I really need to correct or if someone can explain a better way to do this I would be most grateful as well...