Turning text into numbers

  • Thread starter Thread starter Billy Thomas
  • Start date Start date
B

Billy Thomas

Hi,

Using Excel97, I am trying to set up a sheet where I can enter whole numbers
or fractions [example..1/8] in a column (A), and multiply the numbers in
that column by numbers in another column (B), with the results appearing in
column C. My problem is that I want the fractions to appear as fractions,
such as 1/8, but still multiply. An example follows, where column A x column
B = column C.
A B C
5 6 30.00
2 10 20.00
1/8 24 3.00
7 12 84.00
4/15 20 7.47

Thank you for any help.

Billy
 
If you enter your fractions as, say

0 1/8

and

0 4/15

or if you prefomat the cells with

Format/Cells/Number/Fraction and choose "up to 2 digits"

or, perhaps

Format/Cells/Number/Custom and enter # ??/??

which is the same thing...

then you just need to enter

C1: =A1 * B1

and copy down.
 
Back
Top