The Format Function

The Format function is used to format strings, numbers, and dates. Table 8-3 gives a few examples.

Table 8-3. Format Function Examples


Return value

Format(Date, "Long Date")

Thursday, April 30, 1998

Format(Time, "Long Time")

5:03:47 PM

Format(Date, "mm/dd/yy hh:mm:ss AMPM")

04/30/98 12:00:00 AM

Format(1234.5, "$##,##0.00")


Format("HELLO", "<")


Tea 87Fly®

0 0

Post a comment