Floor()
tried i actually solved it the bad part is that i have to create 4 more local variables for each item i have and alot more events sheets for each value distance E.G. =>1000 <=99999 and so on for ten,hundreds, mil,ten mils,hundred mil, etc hundred billions, its tedious but solved the problem i had
and floor does not work for more then value 1000 because if i use floor and have 10000 will give me 10.0 K for some reason automatically removes the decimal but adds another decimal point after 10, for 10,000 and the rest above numbers... i want in future not to have to write 100, lines for 10 items and have like 40 different events for each combination and range of values.... thanks for your help