Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
statusquo
 
Posts: n/a
Default References to Blank Cells turn into Zeros


Hi,

This is really annoying, but whenever I make a reference to a blank
cell, it turns into a zero, not a blank cell. Is there any easy way to
fix this?

Thanks


--
statusquo
------------------------------------------------------------------------
statusquo's Profile: http://www.excelforum.com/member.php...o&userid=29501
View this thread: http://www.excelforum.com/showthread...hreadid=492931

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyer
 
Posts: n/a
Default References to Blank Cells turn into Zeros

One way:

=IF(Sheet1!A1<"",Sheet1!A1,"")

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"statusquo" wrote
in message ...

Hi,

This is really annoying, but whenever I make a reference to a blank
cell, it turns into a zero, not a blank cell. Is there any easy way to
fix this?

Thanks


--
statusquo
------------------------------------------------------------------------
statusquo's Profile:

http://www.excelforum.com/member.php...o&userid=29501
View this thread: http://www.excelforum.com/showthread...hreadid=492931


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
statusquo
 
Posts: n/a
Default References to Blank Cells turn into Zeros


That will work, but it's a real pain to write that every time,
especially when I'm using an indirect to a different sheet, so the
formula gets extremely long. Is there some sort of formatting option
that can help fix this for me?


--
statusquo
------------------------------------------------------------------------
statusquo's Profile: http://www.excelforum.com/member.php...o&userid=29501
View this thread: http://www.excelforum.com/showthread...hreadid=492931

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default References to Blank Cells turn into Zeros

Of course will not work if you really want to view "real" zeros since they
will not be visible

General,-General;;

whatever number format you use end with 2 semi colons

0.00;-0.00;;

you can also turn them off via toolsoptionsview but that will affect the
lot, this will only affect those that you format and you can use the format
painter

--
Regards,

Peo Sjoblom

(No private emails please)


"statusquo" wrote
in message ...

That will work, but it's a real pain to write that every time,
especially when I'm using an indirect to a different sheet, so the
formula gets extremely long. Is there some sort of formatting option
that can help fix this for me?


--
statusquo
------------------------------------------------------------------------
statusquo's Profile:
http://www.excelforum.com/member.php...o&userid=29501
View this thread: http://www.excelforum.com/showthread...hreadid=492931


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
Excel inserted 0's in cells linked to blank cells lburg801 Excel Discussion (Misc queries) 5 October 28th 05 11:32 PM
I want blank cells, but they're all zeros now that I have formatted them hays4 Excel Discussion (Misc queries) 1 October 13th 05 02:39 PM
Deleting Blank Cells Wholesale? Trey Excel Discussion (Misc queries) 1 October 6th 05 09:37 PM
CONCATENATE problem with blank cells roger_home Excel Discussion (Misc queries) 1 August 17th 05 09:18 PM
How can I make the graph omit blank cells in the data set? easy Charts and Charting in Excel 3 March 17th 05 03:48 PM


All times are GMT +1. The time now is 02:30 PM.

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"