suppress zeroes w/out " "" " ?

T

turtleman2

*to Frank & Hawkide,

thanks for taking the time to respond [:)
Frank's idea sounded good, but custom format's aren't supported b
my version of pocket excel.
Hawkide, your suggestion
=IF(ISTEXT(C1),"",<insert original calculation>)
didn't quite work for me (still got an error msg), but I changed i
to
=IF(ISTEXT(C1), ,<insert original calculation>)
and it worked just fine. Thanks also for getting me interested i
the
"IF(ISTEXT)" function; that's the first time I've ever used it.

Have Fun!

turtleman.
 
Top