msgbox application.text(123.53,"0.00%")
worked ok.

but depending on what you're doing, maybe VBA's Format is what you want:
msgbox format(123.53,"0.00%")

(there are a few formats that aren't shared between these similar functions.)


Tory Zimmerman wrote:

When using the TEXT function I get the following message:

"Compile Error: Sub or Function not defined" It is
supposed to be a built in function such as Left$ or
Instr. It is in the help. If you can go to help, type in
functions and a list of all VBA functions come up click
on T then go to the TEXT function. I tried to duplicate
the example but still get the message about Sub or
Function not defined.

Call me if you care to

Tory
(714) 638-5714

--

Dave Peterson