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
|