One way: Copy the data to the range H1:M1. Highlight the range, then click
on DATA ... SORT. Click on the OPTIONS button and select "left to right".
Then click OK and sort ascending.

"Steved" wrote in message
...
Hello from Steved

in Cells A1 to F1 I have

25, 2, 3, 12, 23, 1

ok in cells H1 to M1 Iwould like to have

1, 2, 3, 12, 23, 25 ie lowest to the highest

What formula would I use in H1 to M1 to acheive this please.

Thankyou.