Thread: Format question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Format question

Whenever I use this formula to show days, it returns a string of decimal
places like 3.66666666 days. I would like for it to show something like 3
days 6 hours. Here is the formula I'm using =SUM(G:G)/L1&"Days" Thanks in
advance!!!