![]() Again, you will see another dialogue box.Thirdly, you will see a dialogue box naming Convert Text to Column Wizards – Step 1 of 3 will pop up.From there, select the Text to Columns command.Then, go to the Data tab of the ribbon.Firstly, select all the numbers that you want to convert.Go through the following steps to know more about this feature. Inserting Text to Columns Wizard to Convert Number to Text in ExcelĪnother way of converting number to text in Excel is to insert the Text to Columns Wizard feature. Read More: How to Convert Numbers to Texts/Words in ExcelĢ. Lastly, use the AutoFill feature to drag down the formula for the consecutive numbers.Finally, press Enter and the number 450 will turn into text format.So, after converting into text it will become six-digit long.In this formula, in the second argument, we will input six zeroes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |