Thread: Format Ratio Q
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seanie Seanie is offline
external usenet poster
 
Posts: 202
Default Format Ratio Q

How can I express below in a ratio format? It returns an invalid
error. If I was to just do it without the text, I'd simply FORMAT,
custom 0.0" :1", but it doesn't seem to work that way here. Any
suggestions?

="don't "&TEXT(C14/D14,"0.0" :1"")