View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Elena Elena is offline
external usenet poster
 
Posts: 43
Default Display #'s incorrectly (format)

=IF(AND(H3-O$1<0,M3-O$1<0,H3<M3),"Past due
"&-MAX(H3-O$1,M3-O$1),MAX(H3-O$1,M3-O$1,0))

Formula above works great (Thanks to those that helped), but the problem I'm
now having is when account is not past due the other #'s return with serveral
0's. Example:00000 or 00221
I would like 221 to appear verses 00221 or 0 versas 0000
--
Elena