Currency formatting - numeric, zero fill

#1

I need to format a currency field to export to an excel file. The
field must be numeric, zero fill and in the format of 00000010.00 (10
dollars), for example. I am currently using
val(format([currency_amt],"00000000.00")). Is this correct?

#2

Annette wrote:

Quote:

I need to format a currency field to export to an excel file. The
field must be numeric, zero fill and in the format of 00000010.00 (10
dollars), for example. I am currently using
val(format([currency_amt],"00000000.00")). Is this correct?

Does it work for you?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currency formatting - numeric, zero fill

comp.databases.ms-access comp.databases.ms-access

Currency formatting - numeric, zero fill - 10-25-2011 , 06:30 AM

Re: Currency formatting - numeric, zero fill - 10-25-2011 , 08:08 AM