With Format([SommeDeMontantTotal];"#,##") I obtain 255 $. I would like to obtain 254,78 $

C

Céline Brien

Hi everybody,
In a text box, in a long formula with text and field, how do I get 254,78 $
from a monetary field ?
I tried this Format([Total];"#,##") and obtain this 255 $
Thank you very much for your help,
Céline
 
C

Céline Brien

Hi,
I finally, after previous search, found it with Google : "#0.00"
I had tried "#0,00"... but it did'nt work.
Have a good day,
Céline
 

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

Using <= in countifs statement 1
Converting URLs in comments to Markdown-formatted links 2
Printing Outline view - formatting lost 0
Conditional formatting will not work with Now() 3
ASK Field Formatting 1
Link a text box based on drop down box with four options MS Word 365 0
Formatting multiple headings on a document 1
How to have two tables on same line? 1

Top