Digits in text cannot format as Numbers ?

  • Thread starter Thread starter st24961
  • Start date Start date
S

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
 
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
:)
 
Back
Top