Nokia N900 - Does Nokia N900 work as a modem with MAC?

Yes.

For guidance to set up your Nokia N900 as a modem with Mac, see the following links:

http://www.youtube.com/watch?v=5vSqGSG9riU

http://talk.maemo.org/showthread.php?t=35680