Once again I am defeated by Excel. DRAT!!! AND CURSES!!
Here's the seemingly simple problem: take a bunch o' numbers in a column, representing dollars, which have 4 decimal places for cents (in most cases - a few number are whole dollars). Get them to accurately round to the nearest cent, and then have it accurately display as whole (rounded) cents.
Of course I tried ROUND, to no avail, got a number that displayed like it was correctly rounded, but when I merged it it displayed without $ oand with 4 digits after the decimal. This is a pretty short list, 26 items per column, and I could easily key in the correct dollars & cents, but I know there has to be a way to make this go faster with a function. Can you point me in the right direction? Any help is gratefully accepted. Thanks.
Mark aka
LTUser54
Boston, MA
Bookmarks