Peo,
ROCK ON! That was excellent and works quicker than my other solution of a
MACRO to select each cell.
Thanks,
NA
"Peo Sjoblom" wrote:
Format the range as numbers or general, select an empty cell, copy it, select
the text numbers and do editpaste special and select add
Regards,
Peo Sjoblom
"NorbyAngell" wrote:
I export a file from Access and go into Excel to manipulate the .xls
For some reason the fields are not numbers. I choose the formatting, and
manipulate it, but still it's not a recognized number. I hit the sigma for
AutoSum and even autosum does not recognize as numbers, and if I do a
=sum(range:range) I get 0.0000 in the format I chose for the column.
The only way to activate the number as a number is to click it in the value
bar, and it will show up in the auto sum. I have 48 tabs full of these
numbers, need help with it!
Thanks
|