kg still isn't listed together. I was calling into account Mike saying that
kg isn't recognized, and then erred again when multiplying by 100 instead of
1000. You are just upset at me because of the other post regarding budget
redemption.
--
** John C **


"David Biddulph" wrote:

Does your help for the CONVERT function not include the part that says:
"The following abbreviated unit prefixes can be prepended to any metric
from_unit or to_unit.Prefix Multiplier Abbreviation
exa 1E+18 "E"
peta 1E+15 "P"
tera 1E+12 "T"
giga 1E+09 "G"
mega 1E+06 "M"
kilo 1E+03 "k"
hecto 1E+02 "h"
dekao 1E+01 "e"
deci 1E-01 "d"
centi 1E-02 "c"
milli 1E-03 "m"
micro 1E-06 "u"
nano 1E-09 "n"
pico 1E-12 "p"
femto 1E-15 "f"
atto 1E-18 "a"
" ?
--
David Biddulph

"John C" <johnc@stateofdenial wrote in message
...
Well, that's not entirely accurate. kg IS recognized by xl2003, even
though
not listed in help.

Also, I think you meant to multiply by 1000, not 100, in your formula.

:D
--
** John C **

"Mike H" wrote:

Hi,

Neither of those arguments are accepted by convert

Try

=CONVERT(A1*100,"g","lbm")

or work in grammes in a1

Mike
"smason" wrote:

Hello can some one see whats wrong with this formular
=CONVERT(A1,"kg","lb") where a1 = 10

i want to convert a1 from kg to lb but i am getting the N/A# in the
results
i have the addisn installed ana tools pack and solver

any ideas