thedeadzeds
Active Member
- Joined
- Aug 16, 2011
- Messages
- 450
- Office Version
- 365
- Platform
- Windows
Hi Guys,
How do I convert a column of numbers to text where the desired result always needs to be 6 digits. The desired result should have zero at the start depending on how many numbers there are. Number column will not exceed 5 digits
How do I convert a column of numbers to text where the desired result always needs to be 6 digits. The desired result should have zero at the start depending on how many numbers there are. Number column will not exceed 5 digits
Number | Desired result |
678 | 000678 |
647 | 000641 |
11421 | 011421 |
1161 | 001161 |