View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Sheakley John Sheakley is offline
external usenet poster
 
Posts: 2
Default Negative dates or times are displayed as ####

Negative dates or times are displayed as ####. The cell retains the
negative value. How can I display negative time as "h:mm AM/PM" in red or
with a negative sign? The cell should retain the negative value.