AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Decimal to text converter12/26/2023 ![]() You will see a tiny triangle appear in the top-left corner of each cell in your helper column, which means the entries are now text versions of the numbers in your main column. On the Paste Special dialog, select the Values radio button in the Paste group.Then press the Ctrl + Alt + V shortcut to display the Paste Special dialog box. Now you need to convert formulas to values in the helper column.You will see the alignment change to left in the helper column after applying the formula.Copy the formula across the column using the fill handle.In the formula, C2 is the address of the first cell with the numbers to convert. ![]()
0 Comments
Read More
Leave a Reply. |