I have a FoxPro table that I am saving into Excel. Some numerical fields in FoxPro have to be set as Char to allow the correct amount of decimal points to show. When this data is saved into excel, it does not allow you to format the fields to change them to number so that analysis may be done. The only way to change them is to edit every field. I can't seem to figure out why it won't allow me to change the formatting. Something seems to be holding the char format in Excel.

Any ideas?

Thanks!