Pasting Links

H

hce

Hi Everyone

I am really really really hopeless!!! It's me again!!! I was pastin
column a to c from sheet1 to sheet2. It's working fine but the zero
are driving me crazy. There will be zeros if there's no value in th
cell. How can we get rid of these zeros and at the same time, stil
keep the links?

Cheer
 
F

Frank Kabel

Hi
I assume you use a formula lie
='sheet1'!A1
change this to
=IF('Sheet1'!A1="","",'sheet1'!A1)
and copy this formula
 
B

BrianB

Use a custom number format that puts a blank for zero values like :-
#,##0;[Red](#,##0);
(note the semi-colon at the end, after which we can define a format fo
zero values. Nothing there, nothing in the cell
 
Top