I use functions to change price lists, but I don't need the currency shown
with decimal points, even though I use the format cell facility and request
settings with whole numbers only at times the answer is shown to 2 decimal
places and cannot be changed using the format cell. Why is this?
For example I have a trade price of 1283 which I multiply by 2.4 to give
3079 in an adjacent cell when I view this in the formula bar it shows 3079.2
which I don't want as this data is uploaded to a database and needs to be
whole numbers.
Bookmarks