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