I use the following equation to calculate the grams for a material weigh
up. There is a sister equation that calculates the same thing in pounds minus
the *454.

=IF(ISBLANK(G14),"",(($F$11/($C$11/100))*(G14/100)) *454 & " gr.")

G14 = 1.27480 Percent of weigh up.
F11 = 220 Blend Pounds.
C11 = 2 Percentage of total Blend.

Working the equasion yields: 63843.296 gr.

What I am looking for is some way to format this to 4 places after the
decimal. Many times our number will have an ton of places past the decimal
making it very hard to read. Also due to the "gr" text concantenated to the
number, I can't use the standard format cell routine. Is there a format
command I can use in the equation to format the number before I concantenate
the "gr" to it? Thank you in advance for your help.