Re: [xsl] Creating a cheque type format using format-number (e.g. $********123.45CR)`

["andrew welch" <andrew.j.welch@xxxxxxxxx>]

How about:

format-number(124456.78, '$*******###,###.00CR')



On 6/8/06, Ian & Chris <bakeric@xxxxxxxxxxxxxxx> wrote:
> Hi all
>
> I was wondering if anybody has been able to create the following type of
> string using format-number()
>
> $*******123,456.78
>
> The xml tag will look like:
>
> <myTag> 123456.78 </myTag>
>
> I have tried many different methods, but none seem to work, any ideas?
>
> The format number can be done, without the '*' as follows:
>
> Format-number(124456.78, '$###,.00, $###,.00CR')
>
> But I cannot get it to place a set of ******, at the front of the number,
> any ideas????, **** cannot have any ',' commas.
>
> Any help would be appreciated,
>
> Ian.