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 C3 and type =Value(B3). This would convert the first cell of text to data. Use the fill-handle to copy this down to the other 2 rows.
 Sometimes when you import data from another source, it may appear

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!