Data in cells is actually labels not values

  • Thread starter Thread starter jruppert
  • Start date Start date
J

jruppert

I have received a spreadsheet from a collegue that i need to us
formulas in. The problem is that the data in the cells, which ar
various numbers, are actually Labels and not Values. I checked thi
with the CELL() function.

So, is there an easy way to fix the entire spreadsheet short of usin
the VALUE() function on every cell?

thank
 
J,

Here's one way I handle that problem. Copy a blank cell
somewhere in your spreadsheet or off another open Excel
spreadsheet. Select the entire worksheet you need to
convert to numbers and click Edit -> Paste Special -> Add.

This will leave any "real" text in your spreadsheet
intact, but will convert all the numbers to "real" numbers.

HTH

Eric
 
Back
Top