two formats in one cell

M

maxtrixx

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
 
M

Miguel Zapico

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
 
Top