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 |
