Format Currency with no decimal places eg $1000
Posted on 2003-11-17
I've got a program that deals with BIG (multi-million) dollar values. The user isn't interested in seeing the cents, but they DO want to see the currency symbol. Fair enough.
If I use the VB Format(MyNumber,"Currency") syntax, VB always displays two decimal places (even if the number has been rounded first, i .e. Format(Round(MyNumber,0),"Currency") will give $100,00.00.
How can I display these numbers with the appropriate currency formating for the users machine (it's used worldwide) and hide the last two decimal places?
Will raise the amount of points if it turns out to be a WinAPI type solution.
It seems so easy.....