By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,734 Members | 1,392 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,734 IT Pros & Developers. It's quick & easy.

How to apply currency to part of the text box?

P: 72
Hi,
the following text box works:

=[BP QTR Number] & " " & "Basis Points on total assets of" & " " & [Assests]

The result is:
11.75 Basis point on total assets of 5267618.65

5267618.65 is the text box [Assests]

How do I make the assests box currency format, like this:
11.75 Basis point on total assets of $5,267,618.65

Thanks in advance
May 30 '07 #1
Share this Question
Share on Google+
2 Replies

Rabbit
Expert Mod 10K+
P: 12,441
Set the format property of the box to currency.
May 30 '07 #2

P: 72
I just want to share with you the answer and it works:
=[BP QTR Number] & " " & "Basis Points on total assets of" & " " & Format([Assests],"$#,###.##")
Thanks
May 30 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.