Hyphens in Excel Sort
Does anyone know why Microsoft would ignore hyphens and apostrophes in the
sort? The help says it was designed to be consistant with Windows. Our
company uses hyphens in certain positions of the product number, so now if we
sort by product number, it ignores the hyphens and screws up the list.
Any suggestions for getting around this and have a sort use the hyphens?
|