In order to treat them as numbers?
I copied the column from another program which has a list of durations. Unfortunately Excel will not treat these cells as numbers at all so I can't use them in formulas.
I've tried using the Format Cells tool and selecting "Number", but this does not change the cell at all - it still displays "1 day" and formulas referencing it still do not work.
Is there a simple way where a cell value starts with a number and is appended by a string to just get the number value?