Number format when combined with text

[RodneyW]

Cell G6 is using this formula to calculate the number of weeks between two dates. =DATEDIF($F$5,F6,"d")/7 It is producing a value of 14. That cell has Number format with 0 decimals.

Cell G7 is using this formula to calculate the number of weeks between two dates: =DATEDIF($F$5,F7,"d")/7 It is producing a value of 27. That cell has Number format with 0 decimals.

Cell G29 is using this formula =($G$6&" Weeks Remaining") and produces a result of... 14 weeks remaining - This is what I want.
Cell I29 is using this formula =($G$7&" Weeks Remaining") an produces a result of... 27.1428571428571 weeks remaining. I need the result to have no decimal places.

Both cell G29 and I29 are formatted as "number" with no decimal places.

What am I missing?

Thanks in advance

 

[Fluff]

How about

=INT($G$7)&" Weeks Remaining"

 

[RodneyW]

How about

=INT($G$7)&" Weeks Remaining"

That worked, thank you. Any idea why the other didn't?

 

[Fluff]

Your formula does work, the number format of the cell is irrelevant as the formula returns the actual value, not what you see.