Digits in text cannot format as Numbers ?

Hi,
I receive a weekly report from our IT and the digits (in general format and align to the left though ) cannot be changed to ordinary numbers so that I can sort them in A-Z. When I highlight the whole digit column and format it to Numbers,nothing change. I am running Office 2000 and OS XP Pro. I once saw the latest Office 2003 having a feature to convert such digits to Numbers without any problem. Anyone has a solution or workaround ?

Thanks
Regards
ST

Try one of these methods.

1. Try the following:
Select the column, click Data > Text to columns. Click Finish

2. Another thing.
Supposing the offending column is A, then in another column, use TRIM(A1), and copy down. This will remove any spaces present with the numbers.

Mangesh

Whoa ! What a speedy reply and your first method has clear the problem completely.Tried and worked. Thanks a lot.

Regards
ST

It always does in such cases. Thanks for the feedback.

Mangesh