-----Original Message-----
How do I get an entire column to round to the nearest one
hundredh dollar?
.


The function that I would use is mround. If you add the
Analysis Toolpak from Tools-Addins, you will have access
to the function.

The formula would look like this:
=mround(A1,100)

Rekoj