hello-

I would like to format a cell number type based on another cells value.
For instances I have two columns A and B. Column A is a list of
numbers and column B is a list of units. Depending on what type of
unit is enter in column B, I would like excel to adjust the type of
number in column A. The example below shows a two decimal place number
for units of Amps and a fraction for units of HP. I do not what to
have to manually format column A to accomodate for different types of
units.

ex: A B
10.25 Amps
1/3 HP