Adding text to cell with formula changes rounding

[natrlhy]

Hello all,

Here's my scenario:

In the cell I originally have this function: =SUM(H7:H85)/1024/1024

The output in the cell is: 1,284.78 (formatting is done by right clicking on the cell and changing the output there).

When I add text to the cell I have this function: =SUM(H7:H85)/1024/1024&" GB"

Output is now this: 1284.77679729461 GB

How do I get it to retain the formatting and round it properly?

Thanks!

 

[natrlhy]

So many ways to skin a cat! Thanks! That worked!