![]() 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. |