How to Hide Pound sign (#####)

[thong127]

Hello,

I want to hide the pound sign (#) in my excel sheet Im getting this symbol it saying (dates and times that are negative or too large to display ######.

Thank you.

[Logit]

What formula are you using ?

Or is this VBA macro ?

[thong127]

This formula is from one of the forum guru MOD(C14-B14,1)-"8:00".

[Logit]

What values are in C14 and B14 ?

[shg]

Custom-format the cell as h:mm;; to suppress display of values <= 0

[thong127]

Thank you shg,

it works like magic

[shg]

You're welcome.