How can I format a number as a currency, but with no decimal places being displayed.
I figure I can do it using ‘Formatted as:’ but that changes it into text, right, and I need it as a number as I am using it in a calculation. I just don’t need any decimal places as it tends to be a very big number, e.g. $3,503,465 so I don’t want $3,503,465.24 as it is just to much information as nobody cares about the 24 cents 