MrExcel Publishing
Your One Stop for Excel Tips & Solutions

cell formatting. a zero in the column


Posted by steven scaife on September 26, 2001 6:58 AM

I have a userform where when an item is clicked it is placed in the active cell on the current sheet. I then have it so that 3 sheets in the workbook take the value from the active form. On one of these forms there is a long list of zero's in the blank fields, that i don't want to be there. the formulae i am using is =sheet1!the required cell number. so the formulae in b1 would be =sheet1!b1, b2 would be =sheet1!b2 etc.

what i would like to know is how do i stop the cells from showing a zero when the cell it is looking at is null, so that they are empty. the cell format is general, i changed it to text but it still kept the zero.

any help will be great
cheers in advance

steve


Posted by Aladin Akyurek on September 26, 2001 8:25 AM

Use

=IF(Sheet!B1,Sheet1!B1,"")

etc.

Aladin

========

Posted by steven scaife on September 27, 2001 12:25 AM

This is fine when it is a number in the cell, but if its text i get an #value! in the cell.

any ideas

Posted by Aladin Akyurek on September 27, 2001 10:20 PM


See:

31996.html

===========