Prev: Append Record with Next Consecutive Number (not Autonumber)
Next: Recalculate a field when another field's value changes - JCW
From: Don on 2 Apr 2010 15:06
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


From: John W. Vinson on 2 Apr 2010 15:32
On Fri, 2 Apr 2010 12:06:01 -0700, Don <Don(a)discussions.microsoft.com> wrote:

>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.


--

John W. Vinson [MVP]
From: Don on 2 Apr 2010 17:43
thanks, yes it was a typo, will use
Format([number], "#,###.00")

"John W. Vinson" wrote:

> On Fri, 2 Apr 2010 12:06:01 -0700, Don <Don(a)discussions.microsoft.com> wrote:
>
> >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.
>
>
> --
>
> John W. Vinson [MVP]
> .
>
 | 
Pages: 1
Prev: Append Record with Next Consecutive Number (not Autonumber)
Next: Recalculate a field when another field's value changes - JCW