View previous topic :: View next topic
|
Author |
Message |
nitinkhobragade1
New User
Joined: 07 Mar 2006 Posts: 16
|
|
|
|
Hi
I want to get the amount field in output file in the following format:
Code: |
$222,234,356.00
-$456,567.00
-$333,567.00 |
I tried to achieve this using
but it gives the following result for the smal value -45.00:
The space comes between '$' sign and '-' sign.
Is there any way to get the value as
?
PS: I dont want get the output as
Regards,
Nitin |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
From what I read (which I'm sure you did too), I looks like you are only allowed one floating insertion character, unless somebody comes up with an alternative, you may have to edit the edited field and shift in the minus...... |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
If someone insists on the format you've posetd, i believe it is a job for lines of code rather than a simple PICture. . .
This is the first time i've seen a requirement that the minus sign and the $ had to be shown as -$ in the output. It might be worth the effort to get a buy-in from whatever manager/user on one of the standard output formats. |
|
Back to top |
|
|
|