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.

It has nothing to do with values vs cell references, the name error is
because it is part of the Analysis ToolPak (ATP)
which is an add-in, do toolsadd-ins and select it. Then depending on if it
was installed the first time you might need the Office/Excel CD handy.

--


Regards,


Peo Sjoblom

"Lunblak" wrote in message
...
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.

Apologies, I should have looked more thorough on your post, you still need
to
install the ATP but your formula is off the wall, look in help for CONVERT
function.
You can't convert from grams to milligram using that function, it converts
between metric and imperial.
Since one gram is 1000 milligram so all you need to do is multiply with 1000


=A1*1000

where A1 holds grams

--


Regards,


Peo Sjoblom

"Peo Sjoblom" wrote in message
...
It has nothing to do with values vs cell references, the name error is
because it is part of the Analysis ToolPak (ATP)
which is an add-in, do toolsadd-ins and select it. Then depending on if
it was installed the first time you might need the Office/Excel CD handy.

--


Regards,


Peo Sjoblom

"Lunblak" wrote in message
...
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.

thank you much, I hadn't even thought of doing that way. good old lateral
thinkning.

Thanks

"Peo Sjoblom" wrote:

Apologies, I should have looked more thorough on your post, you still need
to
install the ATP but your formula is off the wall, look in help for CONVERT
function.
You can't convert from grams to milligram using that function, it converts
between metric and imperial.
Since one gram is 1000 milligram so all you need to do is multiply with 1000


=A1*1000

where A1 holds grams

--


Regards,


Peo Sjoblom

"Peo Sjoblom" wrote in message
...
It has nothing to do with values vs cell references, the name error is
because it is part of the Analysis ToolPak (ATP)
which is an add-in, do toolsadd-ins and select it. Then depending on if
it was installed the first time you might need the Office/Excel CD handy.

--


Regards,


Peo Sjoblom

"Lunblak" wrote in message
...
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.