Unless you use a macro there is no way for Excel to convert a cell to another
value in the same cell. You will have to enter the value in, say, cell A1
and have cell A2 contain the formula =A1*6. Whatever you enter in cell A1
will be multiplied by 6 and displayed in A2.

Again, if you want all this to be done in the same cell you need to use a
macro. If you need that let me know.

Hope this helps.

Bill Horton

"pilotjs" wrote:

This should be a very simple fix, I'm just not that schooled in excel and its
formulas. I'm tying to enter one number in a cell and it automatically
convert it to another in the same cell.

example: I'm going from gallons of fuel to weight (lbs). 1 Gal Fuel=6lbs.

it's a simple multiplication formula or it should be.

thanks,
js

thanks for the prompt reply. I understand what you are saying and I could do
that, however, what is this macro you are talking about? It sounds promising.

"William Horton" wrote:

Unless you use a macro there is no way for Excel to convert a cell to another
value in the same cell. You will have to enter the value in, say, cell A1
and have cell A2 contain the formula =A1*6. Whatever you enter in cell A1
will be multiplied by 6 and displayed in A2.

Again, if you want all this to be done in the same cell you need to use a
macro. If you need that let me know.

Hope this helps.

Bill Horton

"pilotjs" wrote:

This should be a very simple fix, I'm just not that schooled in excel and its
formulas. I'm tying to enter one number in a cell and it automatically
convert it to another in the same cell.

example: I'm going from gallons of fuel to weight (lbs). 1 Gal Fuel=6lbs.

it's a simple multiplication formula or it should be.

thanks,
js