Hi. I have a very simple formula.

=IF($J656<"",G655,CodeDisplay(MID($A$1,8,1),$B656 ,$B657))

It finds out if its row has been writen on (Col J must have a value if its
writen on). If so it will copy what information it has above it. If it is
empty it will use my CodeDisplay function to find out if it should display a
blank (it does this if its on a blank row and is inbetween two filled rows)
or display a Dash (Based on if I have A1 say so.

Anyway, on my spreadsheet I have several entries from many different
folders. All the entries from the same folder are bunched together and each
folder is seperated by a blank row. All the formulas on Blank rows show up
as a blank (as they should). The formulas that are on filled rows copy the
value above them (as they should). The problem I have is that if a series of
rows from the same folder have no top entry they turn up as Zeros. They
should just turn up as Blanks by Copying the row above them. They've done
this the past few months I've had them. All of a sudden they are turning up
as zeros. Did I change some option unintentially?! How can I return them
back to showing up as blanks?

Thank you for your help. Sorry for the long post which could easily be just
a few lines. I just like to be as specific as I can.

Abode