Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you convert a fraction to a decimal with 3 places
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you convert a fraction to a decimal with 3 places
can you post example of the 'fraction' cell contents to be converted?
"a.clanton" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you convert a fraction to a decimal with 3 places
fractions are only one type of format
select format in the top menu bar, cells, number, and change from fraction to number -- Greetings from New Zealand "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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert 10 Decimal Places to 2 | Excel Discussion (Misc queries) | |||
How do I convert a fraction to its true decimal, not a date no. | Excel Discussion (Misc queries) | |||
Convert fraction to decimal | Excel Discussion (Misc queries) | |||
convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
convert decimal to inch & fraction | Excel Discussion (Misc queries) |