Convert
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
|