If the cells are formatted text just multiple the column x 1.
You can also use Paste Special to do this: write 1 in a cell, copy it, select the columns with the dates and apply Paste Special and select operation: Multiply
If the cells are formatted text just multiple the column x 1.
You can also use Paste Special to do this: write 1 in a cell, copy it, select the columns with the dates and apply Paste Special and select operation: Multiply
Last edited by rollis13; 01-06-2021 at 09:38 PM.
Posting Permissions
Reply With Quote
Bookmarks