Printing Negative Numbers in Excel

[Jenijokokomo]

I can't get negative numbers to print out in my workbook.
It is 3178 KB and 28 worksheets.
If I enter positive numbers or text in the cells, they print fine.
The problem cells are formatted to display negative numbers in red with parentheses.

All data appears in Print Preview, but it doesn't all print out.
We have tried printing on different HP printer models - LJ 7110, OJ 4050N, OJ d135 - to no avail.

Any ideas?

[snowmonkey]

what version of Excel do you have installed ?

cheers

[Jenijokokomo]

I have Excel 2000.

[snowmonkey]

I'm not a "Excel" person but I thought I should ask so I could dig out some info for you, anyways, since I didn't find anything, would you considered to change the color of the negative numbers the print, would that be an option ?

here is how to change the negative number to print in RED
http://spreadsheets.about.com/librar...lexrednegs.htm

cheers

[Jenijokokomo]

Thanks for the tip.
We discovered that negative numbers will print if we change cell format from Number or Currency to Accounting. The dollar sign is outside the parentheses, but we can live with that. We used Conditional Formatting to make the numbers red if less than zero.

Don't know why this is the case, but it works on all our printers.