Notice of Maintenance on October 9th. Click here for further details.

Leading zeros

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.

Parents
  • 0

    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.

Reply
  • 0

    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.

Children
No Data