formatting currency

#1

my regional options has the currency symbol as a comma (French format)
but I'd expect this
?format(1.2,"#.00")

to display 1.20, yet it displays 1,20

what format should be used to get 1.20 ?

#2

Roger wrote:

Quote:

my regional options has the currency symbol as a comma (French format)
but I'd expect this
?format(1.2,"#.00")

to display 1.20, yet it displays 1,20

what format should be used to get 1.20 ?

Not having to deal with intenation stuff consider this a kludge.
? Replace(Format(1.3,"#.00"),",",".")
1.30

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

formatting currency

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

formatting currency - 09-20-2010 , 07:08 AM

Re: formatting currency - 09-20-2010 , 12:24 PM