View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bony_tony bony_tony is offline
external usenet poster
 
Posts: 76
Default Format Cells to show different values

I currently have this format for my cells in a list - "In "#,##0"
Day(s)";#,##0" Day(s) ago" I would like to be able to show the text
"Today" if the cell value is zero. Also, if possible, I'd like to get
rid of the "(s)" ie if the value is more than 1 or less than -1 it
should say "Days" and say "Day" if equal to 1 or -1.

Also, can someone point me in the direction of a help file/website for
advanced formatting like this..

Thanks
Tony