LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Formatting a Spreadsheet

I know there is probably a simple answer to this, but I have a spreadsheet
that someone else created. In that sheet there are various formulas and 1
column is based on the difference of 2 other columns. The question is about
the column that has the total, if the total is $0 is does not show up, but if
I hightlight several of the cells you can see there are zeros, almost like
the font color is white. There are several cells that I had to change the
formula and now the $0 always show up. How do I make them invisible like the
other cells.

Any help is greatly appreciated
 
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
how do I use the same formatting when I re-create a spreadsheet rhck321 Excel Discussion (Misc queries) 4 December 19th 07 03:55 PM
I have a spreadsheet with conditional formatting. I would like to Barbara KEyt Excel Worksheet Functions 1 March 13th 07 05:57 PM
Spreadsheet formatting Philip Drury Excel Discussion (Misc queries) 6 February 20th 07 04:41 PM
Pasting from another spreadsheet changes formatting Ronan Excel Discussion (Misc queries) 1 September 12th 06 07:28 PM
Formatting Spreadsheet windsong Excel Discussion (Misc queries) 2 October 19th 05 05:54 PM


All times are GMT +1. The time now is 06:42 AM.

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

About Us

"It's about Microsoft Excel"