In cell A2, there is char 2328050010001023841.
The format for those value must be string instead of number based on Excel's
specifications,
which has 15 digit precision.

If I get a list of string under A column, does anyone have any suggestions
on how to sort it in ascending order based on macro coding?
Thank everyone very much for any suggestions
Eric

On 18 Maj, 16:31, Eric wrote:
In cell A2, there is char 2328050010001023841.
The format for those value must be string instead of number based on Excel's
specifications,
which has 15 digit precision.

If I get a list of string under A column, does anyone have any suggestions
on how to sort it in ascending order based on macro coding?
Thank everyone very much for any suggestions
Eric

Hi

Range("A2:A100").Sort Key1:=Range("A2"), Order1:=xlAscending,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

BTW: To enter numbers as text, enter ' (single quotation sign) before
the number.

Regards,
Per

"Eric" wrote in message
...
In cell A2, there is char 2328050010001023841.
The format for those value must be string instead of number based on
Excel's
specifications,
which has 15 digit precision.

If I get a list of string under A column, does anyone have any suggestions
on how to sort it in ascending order based on macro coding?
Thank everyone very much for any suggestions
Eric


See http://www.standards.com/index.html?Sorting

Thank everyone very much for suggestions
Could you please give me more information on where to put those codeing?
I would like to keep column A untouch, and show the sorted results on column
B.