nightdesigns Posted April 8, 2002 Posted April 8, 2002 I have a field that generates an e-mail based from various fields and a total. Unfortunatly, when it calcs out the total, it disregards my formatting for the dollar, and will truncate any zero off the end. I.E. $4.50 comes out as $4.5. Usually with the fields i can set the number of places after the decimal point to show, but how do i get it to do that in a body of text? Thanks. -j
falkaholic Posted April 8, 2002 Posted April 8, 2002 I hear you can use the various text functions on numbers to. Try using Right() and see what happens.
Fitch Posted April 8, 2002 Posted April 8, 2002 We covered this pretty well in a recent thread. To recap: "text... $" & Left(NumToText(Amt + .001), Length(NumToText(Amt + .001)) - 1)
nightdesigns Posted April 8, 2002 Author Posted April 8, 2002 quote: Originally posted by Fitch: We covered this pretty well in a recent thread . To recap: "text... $" & Left(NumToText(Amt + .001), Length(NumToText(Amt + .001)) - 1) That looks like it'll work. Thanks guys.
Recommended Posts
This topic is 8252 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now