>>This might seem quite easy but what would be the best approach to display 745.20 in a format of 99999 where the decimal is removed? For example, that should give 74520. > >
? INT(MyValue*100)
The INT seems to be quite important in here. With it, it provides a proper display when I use something like this: