When I start the import I check the data, and the amount does show in the amount field, but when I import there are no amounts there.
Exactly what import options are you selecting in that dialog box? Is the amount column in the excel file mapped to the correct field in your FileMaker table?
Thanks, I really feel silly because the amount column wasn't mapped and I know better. I was in a hurry and had changed the order around and just missed the fact that it wasn't mapped....
Now I have a new problem with a layout, but I will enter a new post for it....