Quote:
Originally Posted by jyfuller
I have attached the file again. I tried what you said and it is still not sorting. When it sorts it sorts to 0 and then back up. wierd.....
It says it is a numeric value but when I multiply by 1 I get #value. I am really confused please help.
|
Ok I am not entirely sure why but it appears that the spaces in your original distance are actually char characters and not spaces. I have attached the corrected values. Instead of placing a space in the formula I copy and pasted a space from your distance values. It may be Char 255 or 256 again not sure. Using the attached will sort.
Let me know if you have any other questions.