TEXT is a spreadsheet function and not supported (directly) within VBA.
While it is possible to make use of the spreadsheet functions within VBA,
there is a time penalty for the interaction. However, VBA does have a Format
function which will do similar things to the TEXT function. Lots of options
available, so you should check out the help files (and be sure to look as
the "See Also" links as the information is spread out in the help files
among several topics).

Range("A1").Value = "Test " & Format(Range("A11").Value, "0.0%") & " eggs"

Rick


"geebee" (noSPAMs) wrote in message
...
hi,

i thought i had it figurd out... hi,

i have the following in my VBA code:

range("A1").formula = "test " & TEXT(range("A11").value, "0.0%") & " eggs"

i am just trying to format the A11 value as a pecentage. for example, the
value currently in A11 is 109.9. how can i do this?

thanks in advance,
geebee