How to format in a cell that has both text and a formula

[Dave]

I have a cell with this formula


="James Cedric V. Sebua ("& ((TODAY()-B14)/365) & ")"

The display is this
James Cedric V. Sebua (5.55890410958904)

And I want it to be this:
James Cedric V. Sebua (5)

Thanks

Dave

 

[macropod]

Hi Dave,

Try:
="James Cedric V. Sebua ("& INT((TODAY()-B14)/365) & ")"

 

[Dave]

Jezzz
and I was trying to make it so complicated with some kinda
=Formatt(something, something, something )

Thanks so much

Dave

Hi Dave,

Try:
="James Cedric V. Sebua ("& INT((TODAY()-B14)/365) & ")"


--
Cheers
macropod
[Microsoft MVP - Word]

I have a cell with this formula


="James Cedric V. Sebua ("& ((TODAY()-B14)/365) & ")"

The display is this
James Cedric V. Sebua (5.55890410958904)

And I want it to be this:
James Cedric V. Sebua (5)

Thanks

Dave