![]() ![]() In addition, you can format your number codes with dashes or other punctuation marks. This works for number codes that contain fewer than 16 digits. If you want to resolve the issue just within the workbook because it's not used by other programs as a data source, you can use a custom or a special format to keep the leading zeros. Use a custom format to keep the leading zeros If your data changes in the future, you can go to Data > Refresh, and Excel will automatically update your data, and apply your transformations for you. When you're done, Click Close & Load, and Excel will return the query data to your worksheet. ![]() Next, click Replace Current in the Change Column Type dialog, and Excel will convert the selected columns to text. Tip: You can select multiple columns with Ctrl+Left-Click. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |