I am bringing in a .CSV file that does not keep the trailing zeros, now trying to create an accounting style look to numbers, I need the trailing zeros. I understand the use for the FormatNumber, but is there a way to make a global rule for multiple fields instead of having to create so many rules and variables? Would I really need to go through and create a FormatNumber on each Field?
I have something like 152 overall numerical fields that vary in trailing numbers, and like I said, if there is a global functionality to this without having to create a RULE for each Field that would be most excellent. Thanks.