Sorting

When I sort a column of numbers, it comes out like this:

1112
1112
2298
23
5648
889

When I want it to list them from small to big, like this:

23
889
1112
1112
2298
5648

I can understand that the computer thinks the first way is right... but can
I fix this?

The problem is that the computer thinks the numbers are text.

Place a 1 in a blank cell.

Select the cell and Edit/Copy
Select the range of numbers and Edit/Past Special and select the Multiply
option.

That should resolve the problem.

PC



"Kmarie" <[email protected]> wrote in message
news:[email protected]...
> When I sort a column of numbers, it comes out like this:
>
> 1112
> 1112
> 2298
> 23
> 5648
> 889
>
> When I want it to list them from small to big, like this:
>
> 23
> 889
> 1112
> 1112
> 2298
> 5648
>
> I can understand that the computer thinks the first way is right... but
can
> I fix this?

Thank you!

"PC" wrote:

> The problem is that the computer thinks the numbers are text.
>
> Place a 1 in a blank cell.
>
> Select the cell and Edit/Copy
> Select the range of numbers and Edit/Past Special and select the Multiply
> option.
>
> That should resolve the problem.
>
> PC
>
>
>
> "Kmarie" <[email protected]> wrote in message
> news:[email protected]...
> > When I sort a column of numbers, it comes out like this:
> >
> > 1112
> > 1112
> > 2298
> > 23
> > 5648
> > 889
> >
> > When I want it to list them from small to big, like this:
> >
> > 23
> > 889
> > 1112
> > 1112
> > 2298
> > 5648
> >
> > I can understand that the computer thinks the first way is right... but
> can
> > I fix this?
>
>
>