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

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

--
daddylongleg
-----------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...fo&userid=3048
View this thread: http://www.excelforum.com/showthread.php?threadid=55535

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

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