View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ZAkar ZAkar is offline
external usenet poster
 
Posts: 3
Default Round problem with sorting

Hi

I have a 2-dim table holding decimal numbers(2 dec.) and their cell references. Now, after a sort, Visual Basic changes 37.5 to 38 (which makes sense) and we don't want this behaviour. This is annoying when you sort to have the highest values, you don't want 37.5 equal to 38

How can I solve this

Thanks on before hand

Zakar.