Suggestions needed

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

Hi,
I have 2 worksheets that I opened from another
application. The only way I can sort is by retyping the
entire column which would be time-consuming as there are
44,000 entries. Changing the format doesn't work. Copying
and pasting just values doesn't either.

Any suggestions.

Larry
 
I should have been a little more clear.
Click on a blank cell>copy>highlight all cells to change>paste special(add)
or put a 1 in a blank cell>copy>highlight all cells to change>paste
special(multiply)
 
I liked your first suggestion better Don.

The use of a *blank* cell and *add* enables the user to more easily select
an entire range, and not have to perhaps pick and choose particular cells.

Multiply will add zeroes to empty cells, where add leaves them blank.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

I should have been a little more clear.
Click on a blank cell>copy>highlight all cells to change>paste special(add)
or put a 1 in a blank cell>copy>highlight all cells to change>paste
special(multiply)
 
We are talking here about converting text to numeric, I think. In this case
(at least in Excel97), it is also important that the blank cell used is one
formatted as general or a number format - NOT text.
 
Back
Top