format
 

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

format
 

Hi geebee

Range("A1") = Format(Range("A1").Value, "0.00%")

Regards,

Per

"geebee" (noSPAMs) skrev i en meddelelse
...
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

format
 

hi,
see your last post

Regards
FSt1

"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

format
 

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

format
 

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

format
 

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