A colleague of mine ran I ran into a bug in MOSS today with the DVWP.
i.e. It treates numeric fields as text for sorting (when sorting on column headers is enabled), hence if you sorted in ascending order on the column, the values would be like 1, 10, 11, 2, 3 etc.
This happens even though the field is formatted as a number and even when the type is set to x:float. on the sort column.
tags: SharePoint, DVWP, Bug, Sorting, Numeric, MOSS 2007
Cross-posted from tariqayad.com