Thank you for the input, I had already arrived at that work-around, thanks
again for your time and effort.

Was hoping someone could explain how come it sorts one way in Ex03/07
(Compatibility Mode) and entirely differently in Ex07, it is VERY PUZZLING!

Yes, I know we are talking about MS products... LOL

--

MJ


"Herbert Seidenberg" wrote:

Excel 2007
Sort as number.
A workaround.
http://www.mediafire.com/file/nyjwnm...10_26_09a.xlsx
.