Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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!! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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!! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use data to copy/fill other cells. | Excel Discussion (Misc queries) | |||
Where do I enter the PROPER formula in a spreadsheet? | Excel Worksheet Functions | |||
enter data into multiple formulas at once | Excel Worksheet Functions | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Data Base Link | Excel Discussion (Misc queries) |