Thanks in advance for any help,

This should be really easy but I can't seem to find the solution.

I have a number field that I need to format as right justified with padded zeros. For example the number 99 needs to be exported as 0000000099. In the table design, I can change the format to 0000000000 and the values look great in the table, but when I export it as a fixed length field it always comes out as just 99.

Please help me as I'm obviously missing something simple.

Eric

Thanks in advance for any help,

This should be really easy but I can't seem to find the solution.

I have a number field that I need to format as right justified with padded zeros. For example the number 99 needs to be exported as 0000000099. In the table design, I can change the format to 0000000000 and the values look great in the table, but when I export it as a fixed length field it always comes out as just 99.

Please help me as I'm obviously missing something simple.

Eric

Try creating a QUERY to export and set the field:

MyFieldName2:Format([OriginalFieldNameHere],"0000000000")

Then export that query.

Thanks boblarson, I just stumbled on the same solution in another post as well.

Expr2: Format([t_dqua],"0000000000")

many thanks!