LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 34
Default Format for a cell with a formula in it but I don't want the 0 to c

I am trying to format at worksheet and use formula's to reference a different
page. What format can I use so that when there is no information entered in
the referenced cell it doesn't show a 0?


 
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 to format a cell that contains formula Sam Excel Discussion (Misc queries) 4 January 18th 07 11:41 PM
text and formula in the same cell - how do I format this cell?? [email protected] Excel Discussion (Misc queries) 4 December 26th 06 11:36 PM
format a cell with a formula so an empty reference cell shows blan M2 Excel Discussion (Misc queries) 3 November 7th 06 10:42 PM
Formula for cell format? atran Excel Discussion (Misc queries) 2 September 19th 05 04:47 PM
format cell formula Juco New Users to Excel 4 February 13th 05 12:33 PM


All times are GMT +1. The time now is 10:47 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"