changing the sample in Format Cells

[baldi]

I have 2 cells that are linked. when the cells are empty one of the cells has a zero in it. I go to format the cell and the cell is formated to general with a sample to "0". How do I change the sample to a blank so it doesn't have the "0" in it..


thanks

 

[Trevor G]

Perhaps an IF statement might help

=if(A2>0,A2,"")

 

[VoG]

Try a Custom format

0;-0;;

 

[Richard Schollar]

Hi

I take it this cell contains a formula pointing back to the previous cell eg:

=A1

One way you might do this is to use the following formula:

=A1&""

Note though that this will convert any numerics entered into A1 into a textual representation of the number.

An alternative formula:

=IF(A1="","",A1)

 

[baldi]

in some of the cells the general sample is blank and others have a sample with a zero in it. is there any way i can just change the sample to a blank?

 

[Trevor G]

Look at Peters suggestion.

Excel Workbook
	E	F	G	H	I
1		Monday	Tuesday	Wednesday	Thursday
2	Week 1	0	45	90	135
3	Week 2	9	0	-9	-18
4	Week 3	78	78	78	78
5	Week 4	147	98	49	0
6	Week 5	216	118	20	-78
7	Week 6	285	138	-9	-156
8	Week 7	354	158	-38	-234
9	Week 8	423	178	-67	-312
10	Week 9	492	198	-96	-390
Sheet2

After Custom format as suggested

Excel Workbook
	E	F	G	H	I
1		Monday	Tuesday	Wednesday	Thursday
2	Week 1		45	90	135
3	Week 2	9		-9	-18
4	Week 3	78	78	78	78
5	Week 4	147	98	49
6	Week 5	216	118	20	-78
7	Week 6	285	138	-9	-156
8	Week 7	354	158	-38	-234
9	Week 8	423	178	-67	-312
10	Week 9	492	198	-96	-390
Sheet2

 

[baldi]

thanks
petes format worked