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%?
thanks
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%?
thanks
In the menu, select Format > Cells. Select Number tab, and percentage.
Mangesh
correct, but how can we do this in vba to make it automatic??
FormatPercent(range("a1"), 0)
One way:
Range("A1").NumberFormat = "0%"
In article <[email protected]>,
lang0477 <[email protected]>
wrote:
> 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%?
> thanks
abc = Format(0.5, "0.00%")
Mangesh
"lang0477" <[email protected]> wrote in
message news:[email protected]...
>
> correct, but how can we do this in vba to make it automatic??
>
>
> --
> lang0477
> ------------------------------------------------------------------------
> lang0477's Profile:
http://www.excelforum.com/member.php...o&userid=23975
> View this thread: http://www.excelforum.com/showthread...hreadid=377693
>
Those all works, thanks guys
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks