Need help adjusting the input type from Integer to Alphanumeric

Hi

I looked at the file and found it does work as expected
as long as you change all references to an employee in both columns A and B.

Additionally, this line in the macro should be adjusted
.Value = .Value & Format(cell.Value, "00000.")
to
.Value = .Value & Format(cell.Value, "00000") & "."

Unfortunately, the results won't be formatted as nicely as when numbers were used for employee IDs.

- Stu

I think this small change in the 'DoReportingChain' macro will do what you want:

Look for these two line near the bottom…

Please Login or Register  to view this content.

Change that to this.

Please Login or Register  to view this content.

Comments:
- This will insert tilde (~) characters at the start of an employee number when it has fewer than 5 characters.
- Change the tilde to whatever character you feel appropriate.
- There will be a period after each of employee #s
- You should use a monospaced font such as Courier on column E so the characters and periods line up.

Hope this helps,
- Stu