Help formatting a Money value.

I have a money data type I'm reading from a table.   I want to format to string, using two decimal places.  I do not want the trailing zero dropped.  And I want a comma every three places.   Add optionally add the $.

For example:   $3,120,456.50
Who is Participating?
Wayne Taylor (webtubbs)Connect With a Mentor Commented:
You can use the FormatCurrency function.
HLRosenbergerAuthor Commented:
Thanks!  that works great; I was previously not aware of it.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.