Question: Sometimes when you import data from another source, it may appear to Excel to be text rather than numbers. This is easily corrected with the
Sometimes when you import data from another source, it may appear to Excel to be text rather than numbers. This is easily corrected with the function. Suppose that one or more of the cells of data in Total Cost Model was showing as text. If this were the case, Excel would not be able to do calculations with that data. Go to the cell C and type ValueB This would convert the first cell of text to data. Use the fillhandle to copy this down to the other rows.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
