Units in formulae

[noteven47]

Is there a way to retain units when a cell is operated on using a formula?
E.g. A1 contains total mass of coins; could be entered in the cell as 473.94g;
B1 contains total number of coins, say 52.
C1 has the formula to calculate the average mass per coin, =A1/B1 but, if either cell contains anything other than the numbers for the calculation, the units are ignored or else an error is indicated.
I know that the scientifically preferable way in a table is to have the units in the table heading but I was thinking of incorporating a few cells of spreadsheet into a document as part of a sentence to illustrate a point.