Issue:  
Need to format number to either US or Euro currencies. 
 
Solutions: 
US (Dollar): Format$(vardouble, "Currency") or Format(vardouble, "Standard") 
Notes:  
Above snippets assumes database/application currency type is US Dollars. Otherwise, they will return currency to the server's/app's currency default. 
vardouble can be number or string with Format$ 
 
Euro: Format$(vardouble, "€#.##0,00") 
  
previous page
 
  |