Carlos Alberto Alves
caa at highway.com.br
Wed Feb 5 15:43:00 CST 2003
31/01/2003 17:48:16, "Stephen Hait" <shait at mindspring.com> wrote: >From A97 Help: >Custom Formats > >Custom number formats can have one to four sections with >semicolons (;) as the list separator. Each section contains the >format specification for a different type of number. > >Section Description >First The format for positive numbers. >Second The format for negative numbers. >Third The format for zero values. >Fourth The format for Null values. >For example, you could use the following custom Currency >format: > >$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null" > >This number format contains four sections separated by >semicolons and uses a different format for each section. >If you use multiple sections but don't specify a format for each >section, entries for which there is no format either will display >nothing or will default to the formatting of the first section. > >HTH, >Stephen > >> I have a report that displays monetary fields with a 'Standard' >> format, 2 decimal places. >> >> Currently it is showing negative numbers as -1,234.00 >> >> How can I make this display (1,234.00)? >> >> I know this can be done if the field is formatted as Currency, but >> the client doesn't want to see the dollar sign. >> You may also want to try to manipulate Control Panel\Regional Settings. HTH, ****************************** * Carlos Alberto Alves * * Child Neurologist * * Systems Analyst/Programmer * * Rio de Janeiro, Brazil * * mailto:caa at highway.com.br * ******************************