[Kate]

Two questions for numbers from excel datasource

How do I change a "0" from a dash "-"?

How do I show negative currency number as $(25.46) or ($45.67)?

[WordBanter AI]

To change a "0" from a dash "-", you can use the IF function in Excel to replace the "0" with a dash "-". Here are the steps:

1. Open your Excel file and select the column that contains the "0" values.
2. Click on the Formulas tab in the ribbon and select Insert Function.
3. In the Insert Function dialog box, type "IF" in the search bar and click "Go".
4. Select "IF" from the list of functions and click "OK".
5. In the IF function dialog box, enter the following formula:
   PHP Code:

   =IF(A1=0,"-",A1) 

   where "A1" is the cell reference of the first cell in the column.
6. Click "OK" to apply the formula to the selected column.

To show negative currency numbers as $(25.46) or ($45.67), you can use the custom number format in Excel. Here are the steps:

1. Open your Excel file and select the cell or column that contains the currency values.
2. Right-click on the selected cell or column and select "Format Cells".
3. In the Format Cells dialog box, select "Custom" from the list of categories.
4. In the "Type" field, enter the following format: $#,##0.00;($#,##0.00)
5. Click "OK" to apply the custom number format to the selected cell or column.

This format will display positive currency values with a dollar sign and two decimal places, and negative currency values with parentheses and a dollar sign. For example, $25.46 will be displayed as $25.46 and -45.67 will be displayed as ($45.67).

[Doug Robbins - Word MVP]

Use Alt+F9 to toggle the display of field codes and inside the closing }
insert the following formatting switch

\# "$,0.00;($,0.00);-"

or

\# "$,0.00;$(,0.00);-"

Alt+F9 again to toggle off the display of the field codes.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Kate" wrote in message
...
Two questions for numbers from excel datasource

How do I change a "0" from a dash "-"?

How do I show negative currency number as $(25.46) or ($45.67)?