+(-)ve values ends in Dr(Cr)

[sasikumar]

hi
from accounts report i get +ve values ends with Dr & -ve values ends with
Cr.
Can i number format the column so that +ve values display as numbers (
without end Dr ) & -ve values as -numbers ( without end Cr )

TIA

Sasikumar

 

[daddylonglegs]

I don't think you can do that will simple formatting but you coul
convert with a formula in another column...

=LEFT(A1,LEN(A1)-2)*IF(LEFT(RIGHT(A1,2))="D",-1,1

 

[Guest]

Sasikumar, if I understand correctly, you'd like positive-valued entries to
be suffixed by "Dr" and negative-valued entries to be suffixed by "Cr". You
can accomplish this by creating a "Custom" cell number format as follows:

- On one or all of the affected cells, click Format>Cells, then click the
"Number" tab
- Select "Custom" from the "Category" list.
- Paste the following into the "Type" text box:
[>=0]#,##0.00"Dr";[<0]##,##0.00"Cr";General

 

[Guest]

Whoops, sorry, it looks like I provided a solution to give you numbers in the
format you already have. You should apply the solution given by
DaddyLongLegs.

Sasikumar, if I understand correctly, you'd like positive-valued entries to
be suffixed by "Dr" and negative-valued entries to be suffixed by "Cr". You
can accomplish this by creating a "Custom" cell number format as follows:

- On one or all of the affected cells, click Format>Cells, then click the
"Number" tab
- Select "Custom" from the "Category" list.
- Paste the following into the "Type" text box:
[>=0]#,##0.00"Dr";[<0]##,##0.00"Cr";General

hi
from accounts report i get +ve values ends with Dr & -ve values ends with
Cr.
Can i number format the column so that +ve values display as numbers (
without end Dr ) & -ve values as -numbers ( without end Cr )

TIA

Sasikumar