When using the TEXT function in EXCEL 2000 VBA I get the
following error:

Compile Error: Sub or Function not found.

The TEXT fuction is in the list of VBA functions under
the Help. I have tried using the example and still get
the same error.

To get the list of functions do the following.

Go to help. Type in Functions. This should bring up the
alphabetical list. Go to the TEXT function and read the
instructions.