View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Paul Mathews Paul Mathews is offline
external usenet poster
 
Posts: 84
Default +(-)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