How do I remove the leading zeros on a AP Vendor Transactions Report. In the cheque advise column it currently shows roughly 14 zeros before the EFT number. Image pasted below. Thanks in advance.
Notice of Maintenance on October 9th. Click here for further details.
How do I remove the leading zeros on a AP Vendor Transactions Report. In the cheque advise column it currently shows roughly 14 zeros before the EFT number. Image pasted below. Thanks in advance.
Assuming this is displaying a text (string) field, rather than a number, afaik, there is no simple formatting option to remove the leading 0's.
Instead, you can replace the field with a formula like this:
if isnumeric({your_cheque_number_column_name}) then totext(tonumber({yourfield}),0,'')
This would return the text representation of the number with zero decimals and no thousand separator.
Assuming this is displaying a text (string) field, rather than a number, afaik, there is no simple formatting option to remove the leading 0's.
Instead, you can replace the field with a formula like this:
if isnumeric({your_cheque_number_column_name}) then totext(tonumber({yourfield}),0,'')
This would return the text representation of the number with zero decimals and no thousand separator.
*Community Hub is the new name for Sage City