if what you want is formula that will calculate as the value in A11 changes,
try:

Range("A1").Formula = "=""test "" & TEXT(A11, ""0.0%"") & "" eggs"""


--
Hope that helps.

Vergel Adriano


"Vergel Adriano" wrote:

try:

Range("A1").Formula = "test " & Format(Range("A11").Value / 100, "0.0%") & "
eggs"


--
Hope that helps.

Vergel Adriano


"geebee" wrote:

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