Macro range on digital cameras is usually specified in cm (centimeters), which defines the distance between the lens and the target.
Example: The Canon A620 camera has a macro specification of 1cm to 45cm. Meaning that (when in macro mode) the camera can focus from 1cm to 45cm (0.4 to 18 inches). At 1cm, the image of a postage stamp should fill the screen.
Megapixels play no part in the macro specifications.
The Canon A620 would probably do what you want and it sells for around $350.
The very best macro tool is a DSLR (digital single lens reflex) camera fitted with a macro lens. But such a camera and lens will cost about $1,200.
When shooting with macro, you must have the camera on a tripod to prevent camera movement while taking the photo.
I suggest you visit a local camera store and have them demonstrate the macro feature of a Canon A620.
I am a dentist and need to take close up pics of teeth. I'm looking for a digital camera with excellent macro capabilities as well as an excellent zoom for other times. Price-wise I'm looking to spend about $800-$900. Also, does a high megapixel have anything to do with the macro function. In other words, does a camera with an 8mp have any better macro function as a camera witha 3 or 4 mp camera. It seems as if all the camera review sites can be broken down into size of zoom, size of mp, and price. I can never find any info about macro size. Please help me...