Hello folks, I need help for my current assignment.
I have used logic for getting amount number( ex number is 134567 I want that number 1,345.67 in this format) So I used ToString(ToNumber([payment amt]),2,1,".") this in formula tool, I am getting the exact output like 1,345.87 but because of string datatype the amount data I am getting in left aligned. My question is how can I format the number to use of 1000 seperator(,) and decimal places in xlsx. In short after formatting the value I want the data in right aligned with proper amount format(comma seperated and decimal).I tried this by using table tool but I have to give file name in current date format as a suffix of a file
