Hello,

I'm putting together a simple calculator in an Excel 2003 spreadsheet and
would like to simplify it further. The idea would be to have a dropdown list,
populated with factor prefixes "kilo, mega, giga, etc." If the user has a
number such as 76MHz, he would enter 76 in column B and select "MHz" from the
dropdown list in column C. Then, column D would take the value from column A
(an energy) and divide it by B times the factor e.g. A/(B*1,000,000).

It would also be very handy for the result to be expressed by "name" e.g.
250 pico Joules, instead of 2.5E-10.

Tips, suggestions?
--
Cheers,
Stephen