Re: Des2000: Money format mask

Is this what you are looking for. If not please ignore.

HTH Prasad Chavali

Number Format Mask Syntax

The following table describes the tokens you can use in creating a number format mask. To create a number format mask, you build a string using these tokens.

Format Token Explanation

N	Prints one digit, unless it is a leading zero to the 
	left of the decimal point or a trailing zero to the 
	right of the decimal point.

*	Prints one digit, unless it is a leading zero to the 
	left of the decimal point, in which case an aster-
	isk (*) is printed. Trailing zeros to the right of the 
	decimal point are printed.

9	Prints one digit, unless it is a leading zero to the 
	left of the decimal point, in which case a space is 
	printed.  Trailing zeros to the right of the decimal 
	point are printed. 

+	Prints a leading plus (+) for positive values and a 
	leading minus (-) for negative values.  This token 
	must lead the mask.

-	Prints a leading minus (-) for negative values 
	and nothing for positive values.  This token must 
	lead the other tokens.

MI	Prints a minus (-) after negative values and a 

space after positive values.  This token must trail 
	the other tokens.

S	Prints a minus (-) for negative values and a plus 
	(+) for  positive values (wherever the S appears 
	in the mask).  This token must lead or trail the 
	other tokens.

PR	Prints angle brackets (<>) around negative values 
	and spaces around positive values.  This token 
	must trail the other tokens.

( )	Prints parentheses around negative values and 
	spaces around positive values.  The parentheses 

must surround the other tokens.

DB	Prints a "DB" after positive values.  This token 
	must trail the other tokens.

CR	Prints a "CR" after negative values.  This token 
	must trail the other tokens.

Y	Causes no sign symbol to be printed for negative 
	or positive values.

V	Causes the number to be multiplied by 10N, 
	where N is the number of 0, 9, *, and S tokens 
	that appear to the right of the V.

EEEE	Causes the number to be printed in scientific 

notation.  All digit tokens refer to digits of the 
	mantissa.  There must be exactly one digit to the 
	left of the decimal point (displayed or implicit).  
	The token EEEE prints as E followed by a plus 
	(+), if the ordinate is positive or zero, and a mi-
	nus (-), if the ordinate is negative, and two digits 
	representing the ordinate (e.g., E-99).

"string"	Prints the string between the double quotes.  To 
	have double-quotes inside the string, type 

double-quotes back to back ("").

. (period)	Prints a period (.) to separate the integral and 
	fractional parts of a number.

D	Prints the local decimal character to separate the 
	integral and fractional parts of a number.

, (comma)	Prints a comma (,) as the group/thousands sepa-
	rator.

G	Prints the local group/thousands separator.

$	Prints $.

L	Prints the local currency symbol.

C	Prints the ISO currency symbol.

%	Prints %.

" "	Prints a blank space.  (Do not include quotes in 

mask.)

B	Prints a blank space for all zero values, regard-
	less of other tokens.

K	Prints a blank space.

<>	Delineates the beginning and ending of the deci-
	mal-aligned region (i.e., that part of the number 
	that you want aligned with the decimal point in 
	the format mask).  Angle brackets indicate that 
	the number should always occupy the same 
	amount of space.  If necessary, values are padded 
	with blanks to the left or right of the decimal 

point.

RN 	Prints values in uppercase or lowercase Roman 
rn	numerals, respectively.  You cannot enter any 
	other tokens with this token.

Safi Ahlberg <ekasaah_at_eka.ericsson.se> wrote in article <35289F29.BF8D587B_at_eka.ericsson.se>...
> Hello this might seem to be a silly question but I can't find any
> documentation or examples on how a money format mask is composed. There
> is plenty of information on the Date format mask but none on money (or
> number either ?)
>
> --
>
> Regards
> /Safi
>
> ====================================================================
> EKA/N/WI Safi Ahlberg
> Information systems
> Ericsson Components AB Telephone: +46 8 7574834 (ecn: 850-)
> Isafjordsgatan 16 Telefax : +46 8
> 164 81 KISTA-STOCKHOLM Email :
> ekasaah(*NOSPM*)_at_eka.ericsson.se
> SWEDEN Memo : eka.ekasaah
> ====================================================================
>
>
>
Received on Mon Apr 06 1998 - 00:00:00 CEST