Custom field needs leading zero in report.

[ChristineLa]

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

[NicholeVargas]

@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

[ChristineLa]

Perfect, thank you so much!! Chris Langan Canandaigua National Corporation