MrExcel.com - Your One Stop for Excel Tips & Solutions

replacing text

Posted by KC on August 25, 2001 1:02 PM

I have a formula set up that gives me values from another page. Zeros show up if the the cell was blank from the other page. Is there a way to replace the zeroes with dashes?

THANKS

Posted by Tom Urtis on August 25, 2001 1:15 PM

KC:

Try this custom format of those cells:
_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)


Tom Urtis