K
kihmca1
Is there a formula that allows you to copy an array of cells an
paste-values these cells into a different array automatically? If no
please read below...
When importing large tables of numbers from the internet, I tried to d
everything I knew to do to get Excel to recognize them as number
(formatted the cells as numbers, multiplied the cells by 1, and =i
cell>0,cell,"0" but none of these change its format.
After importing data from the internet, it does not allow me to sor
the cells unless I copy/paste-values it first. Maybe there is anothe
way to also get around this; do you know? Since this is just one par
of my large worksheet, I am desperate to find a way to do thi
automatically after copying the data from the net. If you have AN
ideas please let me know how I can get the numbers sorte
automatically.
Thank you kindly, Car
paste-values these cells into a different array automatically? If no
please read below...
When importing large tables of numbers from the internet, I tried to d
everything I knew to do to get Excel to recognize them as number
(formatted the cells as numbers, multiplied the cells by 1, and =i
cell>0,cell,"0" but none of these change its format.
After importing data from the internet, it does not allow me to sor
the cells unless I copy/paste-values it first. Maybe there is anothe
way to also get around this; do you know? Since this is just one par
of my large worksheet, I am desperate to find a way to do thi
automatically after copying the data from the net. If you have AN
ideas please let me know how I can get the numbers sorte
automatically.
Thank you kindly, Car