Convert Currency to String but keep commas

  • Thread starter Thread starter Don
  • Start date Start date
D

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
 
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
Click to expand...

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.
 
thanks, yes it was a typo, will use
Format([number], "#,###.00")

John W. Vinson said:
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
Click to expand...

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.
Click to expand...
 
Back
Top