Good Day to all the great minds out there.
I need a little help with this very simple problem.
I want to be able to treat a colulm of cells as numbers only, even when they include text.
example:
colulm A is quanity but it may contain 12lf
and colulm B is a price if $3.00
and colulm C is the total
I want colulm A to be reconized as a number so that
when A*B=C
Thank you,
I need a little help with this very simple problem.
I want to be able to treat a colulm of cells as numbers only, even when they include text.
example:
colulm A is quanity but it may contain 12lf
and colulm B is a price if $3.00
and colulm C is the total
I want colulm A to be reconized as a number so that
when A*B=C
Thank you,