ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Round problem with sorting (https://www.excelbanter.com/excel-programming/297419-round-problem-sorting.html)

ZAkar

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.


All times are GMT +1. The time now is 02:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com