another VBA newbie question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: lang0477 <lang0477.1qd6yd_1118329662.2199@xxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 9 Jun 2005 10:06:11 -0500

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

--
lang0477
------------------------------------------------------------------------
lang0477's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23975
View this thread: http://www.excelforum.com/showthread.php?threadid=377693

.

Follow-Ups:
- Re: another VBA newbie question
  - From: mangesh_yadav
- Re: another VBA newbie question
  - From: JE McGimpsey
- Re: another VBA newbie question
  - From: skiloa

Prev by Date: Re: Stop running a macro in the middle of a macro
Next by Date: RE: can I assign a macro to a cell?
Previous by thread: I cant do a search on this forum. Everytime I search, it comes up with zero results
Next by thread: Re: another VBA newbie question
Index(es):
- Date
- Thread

Relevant Pages

Re: A Follow up to Userform Formating
... I'd drop the linked cell and have the code change the value in the cell: ... Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) ...
(microsoft.public.excel.misc)
Re: 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%? ... Prev by Date: ...
(microsoft.public.excel.programming)
Copying text from an editable text box to a table cell
... I currently have some code in place to copy text from a table cell to ... another table cell on another slide - something like this... ... to enter their text while in the PPS and the text in the target table would ... How would my code change to make this happen? ...
(microsoft.public.powerpoint)
Easily resolved
... 'Text' formatted cells displaying numbers in scientific format ... I use Excel to view statement information downloaded from my bank in CSV ... some cells still display the numeric string in scientific ... Selecting the cell shows that it's already correctly formatted. ...
(microsoft.public.excel)
Re: Actual solution
... Then format the cells as text ... some cells still display the numeric string in scientific ... Selecting the cell shows that it's already correctly formatted. ... Microsoft Excel MVP ...
(microsoft.public.excel)