View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Emma Chapman 123 Emma Chapman 123 is offline
external usenet poster
 
Posts: 4
Default Formatting a cell

Please can somebody help.
I have a formula in a cell say ing that if the date is less than the date
today put it in this cell if not then enter 0. The cell is formatted as a
date but the zero keeps on coming up as January but i need it to come up as
0. Is this possible to do.