View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Miguel Zapico Miguel Zapico is offline
external usenet poster
 
Posts: 95
Default two formats in one cell

You may try this variation of your formula:
='Resource Info'!E29 & "/" & 'Resource Info'!D29 & "/" & INT('Resource
Info'!E29/'Resource Info'!D29*1000)

Hope this helps,
Miguel

"maxtrixx" wrote:

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