+(-)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 could convert with a formula in another column...

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

[Paul Mathews]

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

"sasikumar" wrote:

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

[Paul Mathews]

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.

"Paul Mathews" wrote:

> 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
>
> "sasikumar" wrote:
>
> > 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
> >
> >
> >