How to set a no-display value to cells with a no-value link

		Microsoft Office Forums > Microsoft Excel > Excel
How to set a no-display value to cells with a no-value link

FAQ

Thread Tools

Display Modes

10-30-2011, 10:45 PM

Catalin.B

Windows Vista How to set a no-display value to cells with a no-value link

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

I noticed that you are not using now R1C1 reference style

There are 2 options, You can use this formula:
=IF(LEN(Sheet1!A4)>0;Sheet1!A4;"")
you might need to change the ";" separator to "," separator, depending on your regional settings.
Or, in excel options-complex-show options for this worksheet : uncheck the option -show a zero in cells with zero value

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Name - Display Name	Jamal NUMAN	Outlook	2	11-21-2010 09:52 PM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
Display the cells which add up to a certain sum	edbyford	Excel	1	11-26-2009 01:30 PM
Display names	Ineedhelp	Outlook	1	05-12-2009 11:28 PM
Shapes Will Not Display	JoeTx	Visio	0	03-13-2008 09:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:51 AM.