AddDollarFormat ( Number )
Rate this function: Average rating: 4.1 (39 votes) Discuss this Custom Function
Jeremiah Small, Soliant Consulting
http://jsmall.us
Turn unformatted number into dollars with commas rounded to nearest penny.
Sample Input:
AddDollarFormat ( 123456789 ) 

Sample Output:

Description:
Note: On 10/5/2006, Micah Woods modified the function to support negative numbers. Thanks Micah.
Note: A typo was fixed in this function on 9/14/2005 which caused the original version to return the wrong value for 7 and 8 figure numbers. Thanks to Angie at Biscuit Technology for reporting the problem :)
This function takes an unformatted number and formats it with dollar sign, commas, and rounds to the nearest penny. It is useful if you need to display dollar results in a concatenated text field with other text. It only will format numbers up to 999,999,999.99. Numbers larger than that will be returned without commas. Of course if you need to format 1 billion dollars and higher, you can afford to have me extend the range if you can't figure out how to do it yourself :)
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:5 most recent comments  Show all 10 comments Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Newest Custom Functions:
1. 
ListSort ( ValueList ) 

(Mon, Aug 21, 11:04am) 
2. 
AddSortOrder ( values ; padWidth ; delimiter ; currentValue ) 

(Wed, Aug 16, 10:37am) 
3. 
AddAddHiddenSortOrder ( values ; currentValue ) 

(Wed, Aug 16, 10:31am) 
4. 
String_to_Number_in_Scientific_Notation ( text ) 

(Tue, Aug 15, 9:20am) 
5. 
Quartic_Solver ( a, b, c , d, e, which_x ) 

(Sun, Aug 13, 1:05pm) 
6. 
SQLRefSimple ( FldRef ; Option1TO2Fld3Both ) 

(Fri, Aug 11, 3:19pm) 
7. 
BinaryStringXOR ( a ; b ) 

(Mon, Aug 07, 1:46pm) 
8. 
VarListCreatorPro ( VarType, VarName, VarValue, Mode) 

(Mon, Aug 07, 1:05pm) 


Um, doesn't this just mean that the student buys the paper beorfe the first draft is due? And that you've probably edited a purchased paper?You can usually purchase different levels of work, on a sliding price scale. So the student buys a B paper, takes it to you, you discuss it and edit it together, and the kid saves the money and gets an A. Now, you can usually get around this, but you have to keep track of the student step by step from the initial planning stages all the way to the final draft. Brainstorming, freewriting, outlining, drafting, etc. You can then have them write a reflection essay on the process itself. And that's all more work than most anyone can actually keep track of, as a teacher.(Also, be aware that your students are also having their friends and family edit i.e., rewrite their work for them.)My solution at the high school level is rather simple. Our curricula specifies that we have to assign one formal takehome essay and one inclass essay test every eight weeks. So I have students write the inclass essay test first. Then they have to revise and expand it (double the size) for their takehome essay, which they submit to a plagiarismchecking website.
Andre, ev4FbdZUIu
November 27, 2015 1:14pm