View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default How do you convert a fraction to a decimal with 3 places

You just need to format the cell.
The cell contains a "real number" as mathematicians call a number which is
not an integer
In your worksheet, it has been formatted to show as a fraction, you need to
format it as a number
Select the cell; use CTRL+1 to open the formatting dialog and set format to
Number with 3 decimals
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"a.clanton" wrote in message
...
I am new to excel and trying to convert a spreadsheet i got which came
with
fractions, I would like to convert them to decimals.