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.In cell C2 please enter the formula =Text (B2, “0”).Value refers to the cell that contains the data you want to convert, and the next part format_text represents in which format you want to see the data.These are the following examples to convert numbers to text:Īs a simple method, you can use this inbuilt function Text which is shown in the below screenshot, and the format is as follows.
You can download this Convert Numbers to Text in Excel Template here – Convert Numbers to Text in Excel Template Step 4 – By selecting the dropdown arrow, it is possible to change the text to its old form using Convert to Number.
If you have only two or three cell data that needs to be converted into text, these are the simple steps you can follow. Excel functions, formula, charts, formatting creating excel dashboard & others Steps to Convert Numbers to Text in Excelīelow mentioned is the easiest way to Convert Numbers to Text in Excel.