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

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
Jezzz
and I was trying to make it so complicated with some kinda
=Formatt(something, something, something )

Thanks so much

Dave

macropod said:
Hi Dave,

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


--
Cheers
macropod
[Microsoft MVP - Word]


Dave said:
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
Click to expand...
Click to expand...
 
Back
Top