I have a spread sheet set up for some test I run for my job. I'm kinda'
teaching myself as i go, how to use all that Excel can offer. right now I
have the spred sheet set up so it will give me the difference between two
cells and present the answer in a different cell, which is great. Now I
wanna' take that result and convert it from Grams to Miligrams. I tried
using this as a formula and it didn't work:

(i will use A1 as an example cell)

=CONVERT(A1,"G","MG")

The Error that came up is:

#NAME?

I figure this is because it actually wants me to put a value in, instead of
A1, but A1 will be changing as every test has a different result.

so, I would like to know a means of acomplishing my goal for this task.

I would also like to know if there is a way to input a formula and have
preexisting text in the same cell. so it would kinda' be like a fill in the
blank where the results of the formula would compleat the blank.

Thank you for any asistance in advance.