VBA Formatting Questions

[rhouston1908]

1. I have a date field within a userform, how do I format that field to display the mm/dd/yy format within a cell?

2. How do I format percentages?

3. How do I format currency? (US Dollars)

 

[tlowry]

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:DoNotOptimizeForBrowser/> </w:WordDocument> </xml><![endif]--> Right click the cell and choose “Format Cells”
Choose the type of data date, number, currency, percentage
Choose format

Alternatively in a macro use the format command i.e.

MsgBox Format(Now(), "dddd, mmmm dd yyyy")

<table style="width: 347px; border-collapse: collapse; height: 41px;" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height:13.2pt"> <td style="width:194.0pt;padding:.55pt .55pt 0in .55pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="323"> Displays: Monday, November 07 2011
</td> </tr> </tbody></table>