Thread: two formats in one cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
maxtrixx maxtrixx is offline
external usenet poster
  
Posts: 1
Default two formats in one cell
I have two values in one cell concatenated using &"/"&. The first part I
want to show two values 12/13. The second part I want to display 925
(=12/13). Is there a way to format one cell to show 12/13/92%? Se formula
below. Thanks!!

='Resource Info'!E29&"/"&'Resource Info'!D29&"/"&'Resource
Info'!E29/'Resource Info'!D29
Reply With QuoteReply With Quote