Change format in access pass-through query

Question

When I run my SQL procedure in Access, which returns a table, the data in table are in unexpected format. Is there a way to change the format of the result table?

Result format: 1.00 XDR
Expected format: 1.00

Answer 1

I got the right solution. In the Sql procedure I format decimal(10,4) values, for example: select format (column1, 'N4') as column1 from ...