formating a data reference within a text cell

  • Thread starter Thread starter V
  • Start date Start date
V

V

I am trying to format a reference to a cell within a text
to display percentage:
My formule reads: ="Regular"&E1&" Bonus", where E1 is
10%, but the cell displays: "Regular 0.1 bonus"

Ho wcan it display "Regular 10% bonus"?

thx

v
 
="Regular "&TEXT(E1,"0%")&" Bonus"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top