Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
John
 
Posts: n/a
Default negative numbers in parenthesis are not clear on excel printout?

positive numbers fonts are darker and easier to read on the printed report? I
would greatly appreciate some help.....
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default negative numbers in parenthesis are not clear on excel printout?

Do you mean that negative numbers are shown in red (or blue) on screen
but you print them out in black & white and so they appear feinter than
positive (black) numbers? If so, you can change the format using Format
| Cells | Number tab | Custom.

Pete

  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default negative numbers in parenthesis are not clear on excel printout?

Maybe it's just a problem with the font size that's printing.

If you can't change the font size (report won't fit on the paper when you do),
maybe you could use format|conditional formatting to bold those numbers that are
negative.

John wrote:

positive numbers fonts are darker and easier to read on the printed report? I
would greatly appreciate some help.....


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
gandhi318
 
Posts: n/a
Default negative numbers in parenthesis are not clear on excel printout?


Hi,
You may try conditional formating from Format Menu
First give conditional formating to first cell of your data or range or
A1 cell
If Cell Value is less than 1 format it in different colour back ground,
less fort size, colour display etc
Then copy this conditional formatted cell to all your data or entire
worksheet as you please


--
gandhi318Posted from - http://www.officehelp.in

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert negative numbers to positive numbers and vice versa bill gras Excel Worksheet Functions 4 December 7th 05 01:39 AM
Add sequences of positive then negative numbers judoist Excel Discussion (Misc queries) 6 November 26th 05 05:51 AM
How do i enter negative times in Excel & how can they be 'fiddled. stuck! Excel Discussion (Misc queries) 2 April 7th 05 02:05 PM
BRACKETED NEGATIVE NUMBERS IN EXCEL Bushco New Users to Excel 2 February 11th 05 01:40 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM


All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"