VBA Percentage

  • Thread starter Thread starter mark1
  • Start date Start date
M

mark1

I have a message box that gives the value of a cell. The
cell itself is in percent format. However, the message
box displays the value in numerical format. How can I get
the message box to display it as a percent? Thanks for
your help!!
 
Format(Range("A1"),"%0")

--

HTH

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