changing the sample in Format Cells

Trevor G

Well-known Member

Joined

Jul 17, 2008

Messages

6,842

Office Version

1. 365

Platform

1. Windows

• Sep 13, 2011

• #2

Perhaps an IF statement might help

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

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Sep 13, 2011

• #3

Try a Custom format

0;-0;;

 

Upvote 0

Richard Schollar

MrExcel MVP

Joined

Apr 19, 2005

Messages

23,707

• Sep 13, 2011

• #4

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)

 

Upvote 0

B

baldi

Board Regular

Joined

Sep 15, 2009

Messages

159

• Sep 13, 2011

• #5

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?

 

Upvote 0

Trevor G

Well-known Member

Joined

Jul 17, 2008

Messages

6,842

Office Version

1. 365

Platform

1. Windows

• Sep 13, 2011

• #6

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

Click to expand...

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

Click to expand...

 

Upvote 0

B

baldi

Board Regular

Joined

Sep 15, 2009

Messages

159

• Sep 13, 2011

• #7

thanks
petes format worked

 

Upvote 0