formula for decimal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Decimal fractions to binary and vice versa 1
Conversions of Decimal Feet to Decimal Inches - Formula?? 0
Addition errors with Decimal Places 5
Excel How To Convert Decimal To Inches 2
the decimals extends after the sum function 2
Removing 3-4 decimals 6
Trim varying decimals from column of numbers 9
Scrabble Value calculation for Welsh words 0

Back
Top