So here we want to make it in a unique way. In the above example, column Data1 consists of integer numbers with different decimal places.If you want to change the whole data into a unique format or a unique number of decimals, then this format is preferred. The missing place values will be filled with “0”. To change the format of the result, we can change the formula as =Text(B1, ”000000”), which will result in the whole data will be shown in six-digit numbers.Or when you change the format of any given data to the text format. The green indication in the upper corner of the cell commonly shows when you have entered a text formatted value into the cell. The numbers are changed into text format. After applying the formula, the values are pasted in the same sheet.Drag and fill up to the range that you want to apply.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |