Space between currency symbol and price - help!

[cfmaster]

Hi guys,

I am trying to figure out how to eliminate a space between a currency symbol and the price being pulled from the database...here is my code:

Price:&pound#NumberFormat(get.price,"99,99999999")

When it displays the price it looks like this: £ 100,000

And...

I want it to look like this: £100,000

Any ideas?

Thanks

 

[ecobb]

Try this:

#NumberFormat(Replace(get.price,' ',''),'99,99999999')#

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[r937]

or this --

#Replace(NumberFormat(get.price,'99,99999999'),' ','')#

r937.com | rudy.ca

 

[cfmaster]

None of the above worked.

 

[r937]

that's interesting, but without further information, it's pretty hard to explain why

would you kindly show me what my proposed solution produces?

r937.com | rudy.ca

 

[cfmaster]

Hi guys...

thanks for your help. I figure it out, to close the gap between the symbol and the number you do the following...

#Replace(NumberFormat(get.price,'L99,99999999'),' ','')#

The 'L' before the number format is the justification.