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.
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