>Most likely you have character field, and Excel does not want to recognize it as numbers when applying NumberFormat. Either reformat it on FoxPro site before importing, or use numeric fields.
>
Using numeric worked, but the number is adjusted to the right, which I don't like. I think I would rather transform it myself.
Thanks again.
If it's not broken, fix it until it is.
My Blog