mkerstei Wrote:
Hey, I need a solution and can't quite figure it out myself. I was
hoping for some good ideas.

I have a cell that people will be inputing data into. This data is
requested in lbs. I need to convert it to metric tons by dividing the
input by 2204.6. I think its a formatting issue, but I don't know how
to custom format it. An example is below.

Example:
They input 10000 in cell C8 as pounds.
As soon as data is entered into C8, it is divided by 2204.6 and that is
what is left displayed in C8.

Does anyone know if this is possible, and what the best practice is for
doing so? Thanks.

Mike

I don't think what you want to accomplish is possible (as far as I
know). What you will enter in cell C8 is what will appear in C8 (if you
enter 10000, it will appear as 10000 all the time).

Perhaps, what you can do is enter the following formula

=C8/2204.62

in, say, cell D8:

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=556273