| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
another VBA newbie question
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 -- lang047 ----------------------------------------------------------------------- lang0477's Profile: http://www.excelforum.com/member.php...fo&userid=2397 View this thread: http://www.excelforum.com/showthread.php?threadid=37769 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
another VBA newbie question
FormatPercent(range("a1"), 0)
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
another VBA newbie question
One way:
Range("A1").NumberFormat = "0%" In article , lang0477 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
another VBA newbie question
In the menu, select Format Cells. Select Number tab, and percentage. Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=377693 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
another VBA newbie question
correct, but how can we do this in vba to make it automatic? -- lang047 ----------------------------------------------------------------------- lang0477's Profile: http://www.excelforum.com/member.php...fo&userid=2397 View this thread: http://www.excelforum.com/showthread.php?threadid=37769 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
another VBA newbie question
abc = Format(0.5, "0.00%")
Mangesh "lang0477" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
another VBA newbie question
Those all works, thanks guys : -- lang047 ----------------------------------------------------------------------- lang0477's Profile: http://www.excelforum.com/member.php...fo&userid=2397 View this thread: http://www.excelforum.com/showthread.php?threadid=37769 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Real Newbie newbie question | New Users to Excel | |||
| Newbie question: | Charts and Charting in Excel | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| Newbie Question | Excel Discussion (Misc queries) | |||
| newbie question | Excel Programming | |||
![lang0477[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
