leading zero issue

[Micheleaz]

I need to take 255.14 and make it a 7 character text field with leading zero's. I can't get the conversion to text right. It still recognizes the decimals and removes teh leading zeros. 255.14 to 0000255

 

[FoFa]

I always use FORMAT to do what you want.
Example FORMAT([MyNumber],"0000000") would format 255.14 to a string like 0000255. FORMAT([MyNumber],"0000.00" Would format it as 0255.14 and
FORMAT([MyNumber]*100,"0000000") would format it like 0025514

 

[Micheleaz]

so in my query, I'd type Total:format[Charges_Total],"0000000"

It's giving me a syntax error.
I'm learning as I go so I'm sorry if it sounds stupid.

 

[pbaldy]

FoFa isn't showing as online, so I'll point out the parentheses in his example and the lack of them in yours. Format() is a function, which you can find more info about in Help.

 

[Micheleaz]

FoFa isn't showing as online, so I'll point out the parentheses in his example and the lack of them in yours. Format() is a function, which you can find more info about in Help.

That worked.
Thanks!