Format number from named range in text string

[Suelizzy]

Hello,

I'm trying to use a named range in a text string. I've almost got it, but the output is a number with several decimal places. On the originating sheet, I've got the number format set at 0 decimal places.

Here's my example:

Named Range from the sheet: "KFH-HP Golf Scorecard" = "KFHStretch". The value shows as "46".

Formula in sheet: "KFH-HP Annual Trends" is "=("PY2016 Target # of Claims = "&KFHStretch&"")". The output is "PY2016 Target # of Claims = 45.90711774"

How do I get the "45.90711774" to just show as "46"?

Thanks for your help!

 

[jim may]

=("PY2016 Target # of Claims = "& TEXT (KFHStretch,"00")&"")" maybe..

 

[Suelizzy]

Perfect! Thanks so much, Jim!