import- number- sort?

B

Brent

I imported this data into a spread sheet- I tried to format it to number,
but when I sort it- I get :

37.08
4.33
4.79
4.8
42.56
5.94


Whats up with this?

Thanks
Brent
 
D

David McRitchie

Correction CHAR(160) is the Required Blank
whereas CHAR(128) is the Euro symbol.
 
R

Ragdyer

If you would prefer a non-code approach, you could try and use,
<Edit> <Replace>
*AFTER* first identifying the actual character that is appended to your
data.

With a "bad" number in A1, enter this in B1:

=Code(Right(A1))

This should give you the Char() value of the "space",
Which is probably Char(160), as David mentioned.

Knowing this Char() value, select all the cells containing these "bad"
numbers, then:
<Edit> <Replace>

In the "Find What" window,
Hold down <Alt>, and enter
0160
Using the numbers from the Num keypad, *not* the numbers under the function
keys.
Since this is a <Space>, you won't see anything displayed in the "Find What"
window.
Don't enter anything in the "Replace With" window.
Hit <Replace All>

This should remove those non-breaking spaces and convert your data to XL
recognizable numbers.
 
B

Brent

Yes it worked well- you hint to use the number pad was the key as the
function key numbers do not work.
Thanks
Brent
 
Top