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

Subject: [xsl] Creating a cheque type format using format-number (e.g. $********123.45CR)`
From: "Ian & Chris" <bakeric@xxxxxxxxxxxxxxx>
Date: Thu, 8 Jun 2006 18:14:23 +1000
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.

Current Thread