Now you need to convert your existing data. This may be done using re-entry after cells have been formatted as text; or - better IMO - using DataText to Columns... feature, where you right-click the column and define Text as its type - then it will convert the whole column at once (which is the function it has been specifically created).
Now you need to convert your existing data. This may be done using re-entry after cells have been formatted as text; or - better IMO - using DataText to Columns... feature, where you right-click the column and define Text as its type - then it will convert the whole column at once (which is the function it has been specifically created).