HI Kirsten Bell I think its going to be the number formatting on your Crystal Report.  If you look at the top-left of this report when its previewed to screen, you will see the path to your customised A/P Vendor Transactions Report template (this field has been added, its not stock).  Please right-click on the field and check the formatting.  Its been added afterwards as its not on the stock report, so you will likely just need to change the formatting.

To confirm there isn't something crazy in the database with a bunch of leading zeros, you can run the following checking you have selected the correct database first:

You manually set the next check number for the selected Check Stock defined in Bank Services, so I'm almost certain there is something crazy in the report adding the leading zeros.  I could be wrong though and you could check the default length of 22 hasn't been left in A/P Options:

Again, check the Crystal Template, I think that's going to be the cause.

Thank you kindly, I will look into the template. Appreciate you responding!

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.