Want to Remove thousand separators and decimal points from a formula

[Bunting]

I have a formula which returns a numeric value such as 1,234.00

The end result I am looking for is to have a fixed length field of 8 charcaters with no thousand separators or decimal points. For example 1,234.00 to show as 00123400

I think I'm O.k with building up to 8 characters with preceeding zeros, but I have a real problem removing ,.

 

[AndrewBaines]

Try:
replace(totext({Sales},"000000.00&quot,".","&quot
Andrew Baines
Chase International

 

[Bunting]

Thnaks for the speedy response - it works - I'm happy.

Ta a lot

 

[Ngolem]

an easier way is simply: totext({Sales},2,"","&quot Jim
JimBroadbent@Hotmail.com

 

[AndrewBaines]

But then you don't get the leading zeroes. Andrew Baines
Chase International