Digits in text cannot format as Numbers ?

[st24961]

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

 

[mangesh_yadav]

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

 

[st24961]

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

Regards
ST

 

[mangesh_yadav]

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

Mangesh