Paste and enter of data

[Guest]

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!!

 

[Guest]

no macro needed

type 1 in another cell somewhere else
copy that cell
select your column that you want to convert to numbers
edit > pastespecial > multiply

- or -

add a new column next to yours
use =A1*1 etc
extend downwards all the way
fix values using copy, pastespecial values on the new column
delete the old column and use the new one instead

 

[Guest]

okay, I think I'm too immensed in code right now, because that was very
non-logical/thinking of me...wow...okay, thanks for the obvious!! haha