Thread: format cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hans
 
Posts: n/a
Default format cell

I have a cell A1 in which I want to print a date dd-mm-yy. This cell is
depending on another cell B1 . In this cell I calculate the number of days by
distracting one date from another. If the number of days is positive A1
should read a date dd-mm-yy, if the number of days is negative A1 should read
0.
A1 gives me 0-1-1900
How can I get 0 in A1 ?