Hi, I have a custom field that holds a GL account number. If that account number has a leading zero then it is dropped in my report. Is there a way to force the leading zero to show? For example account number is 0101 and my report shows 101. Thanks, Chris Chris Langan Canandaigua National Corporation
Topics help categorize Community content and increase your ability to discover relevant content.
@Chris Langan If this number does not ever need to be summed, multiplied or used in any mathematical calculation, I would recommend changing the format of your custom field from Number to Text. This will keep the 0 in front for reporting. If you are unsure how to do this, go into Setup > Custom Forms > Select your Custom Form > Select the Custom Field "GL Account Number" and there you will see a dropdown menu for Format that you will want to adjust. If you have any questions, let me know! Nichole Vargas Customer Programs Specialist, Workfront