format number
 

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. how can i do this?

thanks in advance,
geebee

format number
 

never mind.i figured it out.

thanks


"geebee" wrote:

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. how can i do this?

thanks in advance,
geebee

format number
 

hi,
try this instead....
Range("C1").Formula = "test " & _
Format(Range("A1"), "0.00%") & " eggs"

regards
FSt1

"geebee" wrote:

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. how can i do this?

thanks in advance,
geebee