requiring a formula to convert a number into a decimal form for a calculation
purposes.
eg. a box of butter has 8 blocks in it...but it only has 4 blocks. So one
column has 4 and the other to convert that number into a decimal number of
0.5 instead.
please help

A1 8
B1 4
C1 =B1/A1 or =B1/8



"Jen" wrote in message
...
requiring a formula to convert a number into a decimal form for a
calculation
purposes.
eg. a box of butter has 8 blocks in it...but it only has 4 blocks. So one
column has 4 and the other to convert that number into a decimal number of
0.5 instead.
please help

Jen

=4/8 will return 0.5

With 4 in A1 and 8 in B1, in C1 enter =A1/B1

Gord Dibben Excel MVP

On Mon, 3 Jan 2005 11:57:04 -0800, Jen wrote:

requiring a formula to convert a number into a decimal form for a calculation
purposes.
eg. a box of butter has 8 blocks in it...but it only has 4 blocks. So one
column has 4 and the other to convert that number into a decimal number of
0.5 instead.
please help