VBA Percentage

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!!
 
B

Bob Phillips

Format(Range("A1"),"%0")

--

HTH

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