Post by account_disabled on Dec 15, 2017 9:29:03 GMT
Hello,
I work on a file that has an ID number in one of the columns. It is a six digit ID number. Some of the ID numbers in the spreadsheet are less than six digits. For the ID's that are less than six digits in length, I need to add leading zeros to make them all six digits in length. Is there a way to do this/format this? I know that Microsoft Excel has the capability to do it, but I want to start using Open Office instead.
Please help...
I didn't find the right solution from the Internet.
References:
forum.openoffice.org/en/forum/viewtopic.php?f=9&t=91173
Corporate Promotional Animation
I work on a file that has an ID number in one of the columns. It is a six digit ID number. Some of the ID numbers in the spreadsheet are less than six digits. For the ID's that are less than six digits in length, I need to add leading zeros to make them all six digits in length. Is there a way to do this/format this? I know that Microsoft Excel has the capability to do it, but I want to start using Open Office instead.
Please help...
I didn't find the right solution from the Internet.
References:
forum.openoffice.org/en/forum/viewtopic.php?f=9&t=91173
Corporate Promotional Animation