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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Percent with Text 5
Setting an Icon Set conditional format for a single cell??? 4
Access Test if value is less than percent 0
blank = no formating, <95% Red, >95% Green 12
Help with formula... 1
Dont display anything above 100% 3
Average Formula Help 2
3-Color Scale Vlookup for Current Month/Previous/Pre-Previous 2

Back
Top