Thread: conditionally format anumber format
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Montana Montana is offline
external usenet poster
  
Posts: 33
Default conditionally format anumber format
Yes, in the same cell. If the value is 99, I want it to show 99¢. If it is a
dollar, it should read $1.00, not 100¢
Reply With QuoteReply With Quote