+ Signed Number Format

Hi.

I want to use the function  format-number to to put a number in a  money  format.  This works when the number is either not signed or negatively signed.
The XML we got from our client has a "+" sign like this example:

<xsl:value-of select="format-number(+00003345351.89,'$#,###.00')"/>

This won't work.  The same proble is when I use the function sum() on a column that has positive values represented with  "+" signed numbers.

Any clues
Thanks

Here is the definition of a positive number accoriding to the w3c XML Schema Part 2: Datatypes specs.
So according to these standards an xml can have the "+" infront of a number.
[
3.3.25 positiveInteger
[Definition:]   positiveInteger is ·derived· from nonNegativeInteger by setting the value of ·minInclusive· to be 1. This results in the standard mathematical concept of
the positive integer numbers. The ·value space· of positiveInteger is the infinite set {1,2,...}. The ·base type· of positiveInteger is nonNegativeInteger.

3.3.25.1 Lexical representation
positiveInteger has a lexical representation consisting of an optional positive sign ("+") followed by a finite-length sequence of decimal digits (#x30-#x39). For example: 1, 12678967543233, +100000.

3.3.25.2 Canonical representation
The canonical representation for positiveInteger is defined by prohibiting certain options from the Lexical representation (§3.3.25.1). Specifically, the optional "+" sign is prohibited and leading zeroes are prohibited.
]





 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list