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
|