Thanks. It works as noted.

----- JackD wrote: -----

Note that this needs to be in a TEXT field to work.
Not in a number or cost field.

-Jack


"Jan De Messemaeker" <jandemes at prom hyphen ade dot be> wrote in message
news:%23PV9dM6KEHA.2576@TK2MSFTNGP12.phx.gbl...
> Hi,
>> OK, I should have tried, or anybody could have tried..
> This works:
> (CStr([Actual Cost]*100/[Baseline Cost])) & "%"
>> Greetings
>> --
> Jan De Messemaeker
> Microsoft Project Most Valuable Professional
> [url]http://users.online.be/prom-ade/index.htm[/url]
> 32-495-300 620
> "DYB" <anonymous@discussions.microsoft.com> schreef in bericht
> news:719E9C61-1BED-43DF-80B9-B257136E6C5C@microsoft.com...
>>>> Thanks for the continuing assistance.
>>>> Unfortunately, no luck yet. I'm still getting the #ERROR message.
>>>> Any additional suggestion?. Perhaps, someone could try the formula noted
> below.
>>>> Thanks.
>> ----- Jan De Messemaeker wrote: -----
>>>> Hi,
>>>> Move the closing parenthesis to just after the 100, that should do
> it.
>> HTH
>>>> --
>> Jan De Messemaeker
>> Microsoft Project Most Valuable Professional
>> [url]http://users.online.be/prom-ade/index.htm[/url]
>> 32-495-300 620
>> "dyb" <anonymous@discussions.microsoft.com> schreef in bericht
>> news:8744B434-A40A-484B-AD6E-AC14C8D60F2E@microsoft.com...
>>> Thanks.
>>>> I've tried suggestion below several times with no success. I
keep
> getting
>> #ERROR message.
>>> In general and specifically, I'm trying to derive a formula for %
> SPENT =
>> cStr([Actual Cost]/[Baseline Cost]*100 & "%").
>>> The formula works okay without the cstr string.
>>> Any additional help would be helpful.
>>>>> ----- Dale Howard [MVP] wrote: -----
>>>> dyb --
>>>> Use the convert to string function and concatenate the
> percent sign
>> to the
>>> result of the formula, such as:
>>>> cStr(20/500*100 & "%")
>>>> Hope this helps
>>>> --
>>> Dale A. Howard [MVP]
>>> Enterprise Project Trainer/Consultant
>>> [url]http://www.msprojectexperts.com[/url]
>>> "We wrote the book on Project Server"
>>>>> "dyb" <anonymous@discussions.microsoft.com> wrote in
message
>>>> news:97E02EC7-D932-4972-8479-E276FA96CBA4@microsoft.com...
>>>> How do I add the % symbol to a custom formula in Project 2002
>>>>> e.g. 20/500*100 = 4 %
>>>>>>>