export number format

[wk6pack]

Hi,

I used a query and put in the following: format([type],"0") and it still
exports to 2.00?

SELECT ExportTable.UID, Format([Type],"0") AS fType, ExportTable.Firstname,
ExportTable.MiddleName, ExportTable.Surname, ExportTable.Username,
ExportTable.Password, ExportTable.Grade, ExportTable.School,
ExportTable.Classname, ExportTable.TeacherUID, ExportTable.Filler
FROM ExportTable;
OUTPUT:

ADTHOMAS1,2.00,ADRIANNA,,THOMAS,ADTHOMAS1,student,05,CRAIGFLOWER
ELEMENTARY,,,

What am I doing wrong?

thanks,
Will