D DW Jul 24, 2003 #1 Any one know how to convert text to number, thanks eg: 1000 (text) to 1000 (number)
W walter Jul 24, 2003 #2 You can go to <format <cell <number tab and select (number insteadof text) OR You can copy and special paste the value.
You can go to <format <cell <number tab and select (number insteadof text) OR You can copy and special paste the value.
G Gord Dibben Jul 24, 2003 #3 Copy an empty cell. Select range of data. Paste Special>Add>OK>esc. Gord Dibben Excel MVP - XL97 SR2 & XL2002
Copy an empty cell. Select range of data. Paste Special>Add>OK>esc. Gord Dibben Excel MVP - XL97 SR2 & XL2002
