slepit2
Newbie
Posts: 1
Registered: 12/2/2004
Member Is Offline
|
| posted on 12/6/2004 at 10:34 AM |
|
|
sorting numbers not working when they are formatted
Hi,
the sorting is working great with regular numbers. But when they are formatted depending on the language( for instance 10 000,00) it is not working.
For that case, I case removing the spaces would work but i can't change it in the script since it is unreadable...
Also when I have values like 1,098 and 1,317 and 1,200 and 0 they are not sorted correctly either.
Of course if I remove the formatting it works great again...
slepit2 has attached this image:
|
|
|
kvv
Super Administrator
Posts: 86
Registered: 6/17/2003
Member Is Offline
|
| posted on 12/16/2004 at 10:32 AM |
|
|
You should use Custom sorting function to
be able to sort formatted numbers correctly.
|
|
|