Paste and enter of data
 

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

Paste and enter of data
 

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

--
Allllen


"Matt" wrote:

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

Paste and enter of data
 

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

"Allllen" wrote:

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

--
Allllen


"Matt" wrote:

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