I ended up looking at this problem with our IFS Technical Consultant and we came up with a workable solution. The problem is that I receive numeric data in Excel to be migrated, but I need to present the number with one or more leading zeros to match the base data set up in IFS. Formatting the column to have leading zeros causes the migration to fail because the column is still interpreted as numbers without the leading zeros by the IFS API.What worked was taking advantage of Excel’s willingness to let me COPY a cell built with a formula and then PASTE the cell’s value into the target column.Sample values are 1, 50, 12, and 5.The Excel formula used was =IF(T2<10, CONCAT("00",T2),CONCAT("0",T2)) where T is an unused Excel column into which I copied the problem data.1 becomes the desired 001, 50 becomes 050, 12 becomes 012, and 5 becomes 005. Migration is happy and so am I.This is far from an elegant solution but it’s quick, repeatable, and it works. Good for my migration go
The formatting for Code B is not Text but is Custom with the pattern 000 set to force the needed leading zeros. I’ll try manually adding the distribution and then populating the spreadsheet. Thanks.Lucy
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
