Format as Percent in Formula

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

Hi,

I know this must be somewhere but I can't find it.

I have the following formula:

="M.J.F.("&DOLLAR(Variables!C26,2) &") x "&Variables!C8

Which is all ok, but I need the last variable to be a percent so the cell
shows:

M.J.F.($1850.00) x 10%

and not

M.J.F.($1850.00) x 0.1

Can anyone tell me how I can do this.

Many thanks,
Anthony.
 
How about:

="M.J.F.("&DOLLAR(variables!C26,2) &") x "&TEXT(variables!C8,"0.00%")
 
Back
Top