![]() You can display the Format Cells… window by pressing the Ctrl + 1 shortcut. Now you can either rename the helper column and delete the original one, or copy the results to your main and remove the temporary column. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |