I might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find.
A colleague posted an Excel formula which could be used to zero pad a column in Excel, which was to be used as the ID column for data being integrated to Microsoft Dynamics 365 Business Central. The formula they had used was longer and more convoluted than was needed.
In…
Continue Reading Ian Grieve’s Article on their blog
Excel Snippets: Formula to Zero Pad to 6 Digits
I might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find. A colleague posted an Excel formula which could be used to zero pad a column in Excel, which was to be used as the ID column for data being integrated to Microsoft Dynamics 365 Business Central.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: See Improved Usability for Warehouse and Inventory
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Automate the Reminders Process in Collections
- Dyn365GP2 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Allow Lines with Amounts of Zero on Recurring General Journals
- Dyn365GP2 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Specify Dimensions on Posted Entries Applications With Realized Gains or Losses