+(-)ve values ends in Dr(Cr)
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
|