another VBA newbie question

  • Thread starter Thread starter lang0477
  • Start date Start date
L

lang0477

how can I change a number in the cell to percentage format??
like I have 0.5 in a cell, how can I use vb code change it to 50%?
thank
 
In the menu, select Format > Cells. Select Number tab, and percentage.


Mangesh
 

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

Macro, how to set a cell value to zero 1
How to use OFFSET in VBA 1
using & function 3
problem with percentage in cells 4
How to make 0.5 same as .5 2
How to make a VBA Function return a value in percent format 8
rounding to nearest .5 in vba 12
Conditional format if difference in cell values greater than 0.50% 1

Back
Top