I am pasting information from one sheet to another, and it seems like the
cells don't recognize it as a number. I've tried changing the format but that
doesn't do anything. The only way that the number is "recognized" is if I
double click or F2 and then hit enter, and the number comes through. The only
way I know this is I am trying to do a sum of the entire column, and it shows
as 0 until I start doing the F2/enter bit and then the sums start showing up.
There are about 18,000 lines that I obviously would like to write a macro for
to just take care of this, but I'm not sure of the looping....thanks!!