I have a currency data type. I need to be able to export to a fixed width text file in a numeric format that is 11 characters without the decimal point.
for example 97.37 needs to be 00000009737
I unable to get the correct number
If I use the
Format([Amount],'00000000000')
I get 0000000097...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.