VBA: Format Function

=========
QUESTION
———
How do I format numbers, dates, etc in my VBA code?

 

=========
ANSWER
———
see EXAMPLES

 

=========
EXAMPLES
———
Format(rs!Store, "0000")
Formats a number field that may contain only one digit (i.e. 2) to four digits with leading zeros (i.e. 0002)

———
= Format(Now(), "hh:mm AMPM")
If the current time is 5:04:23 in the afternoon, the expression returns 05:04 PM.

———
= Format(Now(), "Long Time")
Returns current time in the system-defined long time format. 

———
Format(Date, "yyyy-mm-dd")
Returns: 2011-04-25

———
=Format(Now(),"mm/dd/yyyy hh:nn ampm")
Returns: 04/15/2011 10:04 AM

———
Format(Date(),"mmmm d"", ""yyyy")
Returns: June 16, 2007

———
Format(Date(),"Long Date")
Returns: Thursday, June 16, 2007

——— 
Format(xxx, “Currency”)
–shows with two decimal places

Format(xxx, “$#,##0;($#,##0)”)
–Shows with no decimal places
–Puts negatives in parantheses

Format(xxx, “$#,##0″)
–Shows with no decimal places
–no change for negatives

 

=========
APPLIES TO / KEY WORDS
———
VBA
Format()
Format Function

 

=========
REF
———
http://www.your-save-time-and-improve-quality-technologies-online-resource.com/vba-format-command.html
http://www.techonthenet.com/excel/formulas/format_number.php

 


http://www.anysitesupport.com/vba-format-function/
http://anySiteHosting.com

By | 2011-09-14T10:31:22+00:00 September 14th, 2011|Computers, Documentation, Microsoft, VBA|0 Comments