Convert Currency to String but keep commas

[Don]

Hello, I need to take a currency field and store it as text but keep the
commas. Anyone know the syntax for this. Sample text would be 3,54,998.98

Thanks

 

[John W. Vinson]

Hello, I need to take a currency field and store it as text but keep the
commas. Anyone know the syntax for this. Sample text would be 3,54,998.98

Thanks

Is that where you want the commas? Is it a typo, or do you in fact want two
digits between the commas?

If you want the traditional three-digit sets, you can set a Text field to

=Format([number], "Currency")

or omit the currency symbol with

=Format([number], "#,###.00")

If you need to control the spacing of the commas... please explain.

 

[Don]

thanks, yes it was a typo, will use
Format([number], "#,###.00")

Hello, I need to take a currency field and store it as text but keep the
commas. Anyone know the syntax for this. Sample text would be 3,54,998.98

Thanks

Is that where you want the commas? Is it a typo, or do you in fact want two
digits between the commas?

If you want the traditional three-digit sets, you can set a Text field to

=Format([number], "Currency")

or omit the currency symbol with

=Format([number], "#,###.00")

If you need to control the spacing of the commas... please explain.