DavidBroadus
New Member
- Joined
- Jul 9, 2014
- Messages
- 7
When separating telephone numbers to the appropriate format, I change the destination cells in the spreadsheet to 'text', and also change the destination fields to 'text' in the 'text to columns' wizard. The separated numbers, however, still drop leading zeros. How can I retain the leading zeros in the destination columns?