gennario


Copy an empty cell formatted to General or Number.

Select the column of numbers and Paste SpecialAddOKEsc.


Gord Dibben Excel MVP

On Mon, 10 Jan 2005 14:29:02 -0800, "gennario"
wrote:

I have a large spreadsheet with a column that has the numbers formatted as
text. I tried reformatting the column from numbers to text but when I sum the
column with other columns (that are formatted as numbers) it still doesn't
show in the sum. The spreadsheet is too big for me to retype the numbers. Can
anyone please help???