Format Currency to French

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Anyone know wht format string I would need to Change

$100,000.00 to 100 000,00 $
 
Hi Chris,

Usually you would use the Control Panel's Regional and Language Options
to do that. Am I to take it that that is not an option due to certain
reasons? A possible solution, at least for reports might be this:

Replace(Replace(Format(100000.00, "#,##0.00 $"), ",", " "), ".", ",")

Clifford Bass
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Currency formating 4
numeric picture formats 2
Using the data from different record 1
Change currency format in table. 3
comma seperater 1
Get rid of Currency Decimal places 2
valid number formats ? 12
PowerPoint vba ppt to translate presentation from French to English 0

Back
Top