boolean
Posts: 62
|
| Posted: 10/14/2010, 6:50 AM |
|
Hello,
Would you please help me to display the currency in format of
$1,234,467.99
This format is a combination of 2 format options for displaying a Float number
1) $0.00
2) #,##0.00
If I use (1) only, it does not display the comma (,) for thousand.
If I use (2) only, it does not display the $ if the variable has data.
Worst case is that I have to write a custom function, but I prefer to use what we have with CCS.
Thanks alot.
|
 |
 |
datadoit
|
| Posted: 10/14/2010, 7:03 AM |
|
Have you tried $#,##0.00 ?
|
|
|
|
boolean
Posts: 62
|
| Posted: 10/15/2010, 7:50 AM |
|
oh, wow, it does prove something: I'm S...P
Thanks alot datadoit.
|
|
|
|
|
