Currency symbol in Format=[currency]

[Avnish]

Hi,

I want to format my data in the table using magiccell and specify the format to be currency. But I dont want ASPdb to take the currency symbol from the regional settings. Rather I want to supply this. Could you give me the format to be specified for this?

Thanks
Avnish

[Mark]

Avnish,

Try something like this:
dbMagicCell = "(;|[]@)FieldNum||$format=[###,###,###];"

Of course, you may substitute any symbol you want in place of the "$"

See View/Pro Programming Example 4a at:
http://www.aspdbtest.com/

I hope that helps.
Mark



------------
Avnish at 7/11/2002 11:52:45 AM

Hi,

I want to format my data in the table using magiccell and specify the format to be currency. But I dont want ASPdb to take the currency symbol from the regional settings. Rather I want to supply this. Could you give me the format to be specified for this?

Thanks
Avnish

[frank]

I think format[$$$$$###,###,###] or [###,### Yen] will work too, would it?

FK


------------
Mark at 7/11/2002 3:08:21 PM

Avnish,

Try something like this:
dbMagicCell = "(;|[]@)FieldNum||$format=[###,###,###];"

Of course, you may substitute any symbol you want in place of the "$"

See View/Pro Programming Example 4a at:
http://www.aspdbtest.com/

I hope that helps.
Mark



------------
Avnish at 7/11/2002 11:52:45 AM

Hi,

I want to format my data in the table using magiccell and specify the format to be currency. But I dont want ASPdb to take the currency symbol from the regional settings. Rather I want to supply this. Could you give me the format to be specified for this?

Thanks
Avnish

[Avnish]

None of the suggestions work, both give an error 'Error: magic wrapper [#] -> [Format=[$###]'

Please help ASAP....

Thanks
Avnish


------------
frank at 7/20/2002 8:42:25 AM

I think format[$$$$$###,###,###] or [###,### Yen] will work too, would it?

FK


------------
Mark at 7/11/2002 3:08:21 PM

Avnish,

Try something like this:
dbMagicCell = "(;|[]@)FieldNum||$format=[###,###,###];"

Of course, you may substitute any symbol you want in place of the "$"

See View/Pro Programming Example 4a at:
http://www.aspdbtest.com/

I hope that helps.
Mark



------------
Avnish at 7/11/2002 11:52:45 AM

Hi,

I want to format my data in the table using magiccell and specify the format to be currency. But I dont want ASPdb to take the currency symbol from the regional settings. Rather I want to supply this. Could you give me the format to be specified for this?

Thanks
Avnish

[Mark]

Avnish,

Be sure you redefine the delimiters as I described previously:

dbMagicCell = "(;|[]@)FieldNum||$format=[###,###,###];"
The (;|[]@) is IMPORTANT!

Mark


------------
Avnish at 7/25/2002 10:55:08 AM

None of the suggestions work, both give an error 'Error: magic wrapper [#] -> [Format=[$###]'

Please help ASAP....

Thanks
Avnish


------------
frank at 7/20/2002 8:42:25 AM

I think format[$$$$$###,###,###] or [###,### Yen] will work too, would it?

FK


------------
Mark at 7/11/2002 3:08:21 PM

Avnish,

Try something like this:
dbMagicCell = "(;|[]@)FieldNum||$format=[###,###,###];"

Of course, you may substitute any symbol you want in place of the "$"

See View/Pro Programming Example 4a at:
http://www.aspdbtest.com/

I hope that helps.
Mark



------------
Avnish at 7/11/2002 11:52:45 AM

Hi,

I want to format my data in the table using magiccell and specify the format to be currency. But I dont want ASPdb to take the currency symbol from the regional settings. Rather I want to supply this. Could you give me the format to be specified for this?

Thanks
Avnish