NumberFormat - Custom Code - Interactive Example

This page references NumberFormat, a custom script available for download

Try It

Enter a number and click Try It. The result is formatted according to the settings below.

Input
Output
 
What you try is what you get
Open full code example in new window

Note: Make changes below. Typing in the text box code has no effect.
 
currency output
Currency on
Currency symbol
LEFT_OUTSIDE $-1.00 or $1.00- or $(1.00)
LEFT_INSIDE -$1.00 or $1.00- or ($1.00)
RIGHT_INSIDE 1.00$- or -1.00$ or (1.00$)
RIGHT_OUTSIDE   1.00-$ or -1.00$ or (1.00)$
 
negative output
LEFT_DASH -1000
RIGHT_DASH 1000-
PARENTHESIS (1000)
Negative red (Note: Does not turn font red, just wraps in html)
 
input decimal format
PERIOD
COMMA
 
output separator/decimal format
Output separators on
COMMA separator / PERIOD decimal
PERIOD separator / COMMA decimal
 
places output
Number of decimal places (Note: -1 suppresses rounding)
Truncate (instead of round)
About this page: