FormatNumbers ( Number )

Formats Numbers by rounding them and placing thousand separators where they should be.

Average rating: 4.6 (33 votes) Log in to vote

Emily Parks
Bulldog Marketing
http://www.bdogm.com

Sample input:

1005.1

Sample output:

1,005

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let ( [
Amount = Round ( Abs ( Number) ; 0 );
A = Int (Amount);
L = Length ( A )
];
Case( Number < 0; "-" ) &
Case(
L=9 ; Left(A;3) &","& Middle(A;4;3) &","& Right(A;3) ;
L=8 ; Left(A;2) &","& Middle(A;3;3) &","& Right(A;3) ;
L=7 ; Left(A;1) &","& Middle(A;2;3) &","& Right(A;3) ;
L=6 ; Left(A;3) &","& Right(A;3) ;
L=5 ; Left(A;2) &","& Right(A;3) ;
L=4 ; Left(A;1) &","& Right(A;3) ;
A
)//end Case
)//end Let

Using a simple variation on the DollarFormat function.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

FormatNumbers ( Number )

Comments

Support this website.

Support this website.