Data in cells is actually labels not values

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
 
E

Eric

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
 
P

Peo Sjoblom

When you say they are labels, I assume you mean that they are text?
Format the cells as general, copy and empty cell, select the "labels"
and do edit>paste special and check add.. If that doesn't work you must have
invisible
characters, if that's the case you might want to go the macro way

http://www.mvps.org/dmcritchie/excel/join.htm#TrimALL..
 
Top